http://www.sqlservercentral.com/blogs/jamesserra/2011/07/18/sql-server-_1C20_denali_1D203A00_-details-on-the-next-version-of-ssis/

Printed 2014/11/21 01:57PM

SQL Server “Denali”: Details on the next version of SSIS

By James Serra, 2011/07/18

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.

More info:

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


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.