From the course: SQL Server Integration Services

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Extracting data from a source

Extracting data from a source - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial

Extracting data from a source

“

- [Instructor] In this chapter, I'd like to construct a full data flow diagram from beginning to end. Let's start by creating a new project by coming to the file menu, pointing to new and clicking on project. This is will be an integration services project, I'll press next, and I'll call it Data Flows. That'll give a fresh project and a new package to work with. Now when you switch to the data flow tab, you'll see this message stating that package doesn't yet have a data flow task. You click to add one and the interface will update. Now if you switch back to the control flow tab, you'll exactly what happened, it just added in a simple data flow task to the diagram. You can have multiple data flow tasks in a single package. If you go up to the top and add in another one from the tool box, Notice that it has a slightly different name, the original is data flow task, and this one is data flow task one. In a sequel server integration services package, you can't have two tasks with the…

Contents