CTP3 of SQL Server Code Name “Denali” was made available recently, and it offers a lot of new features for SSIS. Some of my favorites are:
The big impression I got out of all the new features is that many of them are the equivalent of what you find in a typical “ETL Framework” that many people have created to improve on SSIS. So, in most cases for new projects you won’t need to use an ETL framework and instead can use the new built-in features of SSIS. Fantastic!
To migrate your packages from SQL Server 2005/2008 to Denali, make sure to check out Migrating Your Projects to Denali.
Video from TechEd: What’s New in Microsoft SQL Server Code-Named Denali for SQL Server Integration Services
SSIS Team Blog: What’s New in SQL Server Denali
Jamie Thomson has a post about the SSIS enhancements in Denali CTP3
Jamie Thomson webinar: New SSIS Features and Enhancements in Denali