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.