SQL Lion

While building an ETL package, it’s very important to control the flow of work as per the requirement. And this can be done by using a SSIS component called Sequence container. The sequence container is a part of Control Flow and a sub part of the global container i.e. Control Flow container. Here we can set the flow of our package by precedence constraints.

The Sequence Container is basically used for grouping same type of tasks and to control them under a separate group. It can group the whole contents of the package into multiple separate control flows. The sequence container can be nested to any level to give more clarity to the process flow.

Here in this article, we will see the steps to control the tasks using Sequence container as well as how to do the same by programming Integration Services.

Read more…

In the world of data warehousing, SQL Server Integration Service (SSIS) is a popular platform for building high performance data integration solutions including Extraction, Transformation and Load (ETL) packages for data warehousing.

But programming Integration Service has become more popular in between SSIS developers recently. So to help SSIS developers for boosting their programming abilities, SQL Lion team has come up with a unique tool called “SSIS Component Explorer”. This tool can be used as a Swiss Army Knife, to hunt down critical problems while developing SSIS package programmatically.

Read more…