Floating FB popout byF5debug

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

 

This is part 16 of the series of article on SSIS where I shall show how to work with sequential Container Task in 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.

You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx

[more]

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

clip_image001

Now add a variable as shown in the below screen.

clip_image002

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

clip_image003

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.

clip_image004

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

clip_image005

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

clip_image006

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

clip_image007

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.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Comments (1) -

Ibrahim
Ibrahim
11/15/2013 6:22:48 AM #

are we missing anything in this script, do we need to add one parent sequence container of all and What is the result we are going to get out of this script.

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter