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 - SQL Server Tutorial
From the course: SQL Server Integration Services
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Understanding tasks in control flow2m 16s
-
(Locked)
The Data Flow task6m 58s
-
(Locked)
The File System tasks4m 52s
-
(Locked)
Modify file attributes1m 41s
-
(Locked)
The Execute Package task2m 31s
-
(Locked)
The Send Mail task4m 13s
-
(Locked)
SQL Server tasks4m 11s
-
(Locked)
Maintenance tasks3m 27s
-
(Locked)
-
-
-
-
-