SSIS 2005 and the building blocks

In working with SQL Server Integration Services it is very important to know the details of the various building blocks that the Visual Studio provides. A building is never built like a monolith. It is rather constructed using the building blocks. Even larger programs are built using reusable smaller programs.

Another important thing to know is how you visualize a building. A good architectural design needs a good knowledge of the materials it can use - the building blocks. Of course you need a good cement and aesthetically pleasing finishing touches. Visual Studio 2005 and now 2008 has all the necessary ingredients.

This article shows one architect's view of using the building blocks to accomplish a particular task and there could be other simpler and more elegant designs possible coming from more experienced and accomplished architects. Read on and see how the blocks are assembled.

http://www.packtpub.com/article/data-processing-using-derived-column-aggregate-data-transformations




I have described in some detail a large number of the building blocks in my book
http://www.packtpub.com/sql-server-integration-services-visual-studio-2005/book

You can get a real jump start by reading this book in a matter of under two weeks.

Integration Services 2008 bug_Bug001

The picture shows it all. The number of rows selected by the Conditional Split looks good [14601+4511=19112]. But the progress tab shows it has started and one of the component is still yellow. The program hangs. This appears to be a real bug and it is repeatable. I use an evaluaion copy of VS Studio 2008 Professional Edition [trial software], the Feb 2008 CTP of SQL Server 2008 and using the Adventure Works database and a ADO.NET source for this example.

At first I thought that there were too many rows to fetch and reduced the number of rows fetched to be small to weed this bug out for observation.