From the course: SQL Server Integration Services

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

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 Buy for my team

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