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.

Create a sequence container

Create a sequence container - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial

Create a sequence container

“

- [Instructor] A complex Control Flow can be better organized using Containers. You'll find them in the Toolbox underneath their own heading. Containers can be used to set up a looping structure to repeat tasks until a condition is met, or to simply group multiple tasks together into a single, meaningful unit of work. The Sequence Container is the one to use when you simply want to group tasks together. To add one to the design surface, double-click on it in the Toolbox, and that'll drop it down. I'm going to zoom my view back out to 100%, just so I have some more room to work, and I'm going to drag and drop it over here on the right. Now, you simply need to add tasks into the Container. If you try and drag one of the existing tasks into the Container, for instance, this Execute SQL Task, I'm going to get this warning message that says I can't move a connected task into the new container because of the precedence constraint. Let's go ahead and say OK to this. However, if I click and…

Contents