.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Sequential Container Task in SSIS - SQL Server Integration Services (SSIS) - Part 16

Posted By:Karthikeyan Anbarasan       Posted Date: March 21, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

In this article we are going to see on how to use a Sequential Task container. This container is used in areas where the process needs to follow certain tasks sequentially. Sequential Task groups the tasks into multiple control flows and executes the process sequentiallyn in SQL Server Integration Services (SSIS).
 

Introduction


In this article we are going to see on how to use a Sequential Task container. This container is used in areas where the process needs to follow certain tasks sequentially. Sequential Task groups the tasks into multiple control flows and executes the process sequentially. We can use this task widely based on our requirement like, disabling a sequence when it should not process, use it when managing multiple tasks at a same time in one location. We can easily disable a set of tasks under sequential task by disabling the sequential task alone which is straight forward. If there are many tasks in our package we can group them based on their sequence and used to collapse and expand them and also to enable and disable them easily.

To follow my series of articles on SSIS packages refer to the below URL's

 

Basics of SSIS and Creating Package - SQL Server Integration Services (SSIS) - Part 1

Transforming SQL Data to Excel Sheet - SQL Server Integration Services (SSIS) - Part 2

Export Data using Wizard - SQL Server Integration Services (SSIS) - Part 3

Import Data using Wizard - SQL Server Integration Services (SSIS) - Part 4

Building and Executing a Package - SQL Server Integration Services (SSIS) - Part 5

Options to execute a package in SSIS - SQL Server Integration Services (SSIS) - Part 6 

Options to Deploy a package in SSIS - SQL Server Integration Services (SSIS) - Part 7

Scripting in SSIS Packages - SQL Server Integration Services (SSIS) - Part 8

Breakpoints in SSIS Packages - SQL Server Integration Services (SSIS) - Part 9

Check Points in SSIS Packages - SQL Server Integration Services (SSIS) - Part 10

Send Mail in SSIS Packages - SQL Server Integration Services (SSIS) - Part 11

For Loop task in SSIS Packages - SQL Server Integration Services (SSIS) - Part 12

Backup Database task in SSIS and Send Mail - SQL Server Integration Services (SSIS) - Part 13

Folder Structure in SSIS - SQL Server Integration Services (SSIS) - Part 14

Conditional Split Task in SSIS - SQL Server Integration Services (SSIS) - Part 15
 

Steps


Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once the project is created, we will see on how to use Sequential Container Task in SSIS packaging.

Once we are into the BIDS, now we will start with drag and dropping a sequential container task on to the designer view as shown in the screen below


Now add a variable as shown in the below screen.


Now we need to create a scrip task by drag and dropping it and double click on it will open the below screen. Here we need to add the variable to the Readonlyvariable as shown below


Now click on the Design Script button, which will open the below window where we need to write script as shown below in the main method.


Now add a sequential container flow for each day of week as shown in the below screen and connect to the script task


Now click on the green arrow of each task and do the same as shown in the below screen shot for different days


After you have given the expressions for each task your screen look like below


Now right click and execute the package. Or Press F5 directly.

Conclusion

So in this article we have seen on how to use a Sequential container task and how to configure and use the same appropriately.


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend