SSIS Denali (2011 – 2012)

SSIS will change quite a lot in Denali. In the next few weeks, I will blog about it. My goal is to share with you how a simple BI solution can be built with SSIS 2011. The solution is comprised of the following SSIS projects:

• Control: Contains the master package. Execute package task has changed a lot in SSIS 2011.
• Staging: Contains packages that load the staging tables.
• DW: Contains packages that load the data warehouse tables.

So, I will be able to assess how a seasoned developer can navigate in the new SSIS Denali paradigm.

Christian