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.

Understanding tasks in control flow

Understanding tasks in control flow - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial

Understanding tasks in control flow

“

- [Instructor] In order to fully leverage integration services in your SQL Server environment, it's going to be important that you get familiar with the wide variety of tasks that are available to use in an SSIS package. Part of that will require that you spend some time exploring the toolbox in Visual Studio to see what each task does, and then think about how you could apply those tasks to your own situation and database's needs. Complex control flows are nothing more than a series of individual steps, so I encourage you to start small with just a single task or two and then work your way up to longer sequences. Because there are lots of different tasks to choose from, I thought it would be helpful to give a broad overview of the different categories of tasks that you could use before diving in to take a look at some of the specific tasks that you might find most helpful. First is the data flow task. This is probably the most common task in integration services. This task extracts…

Contents