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

CTP3 of SQL Server 2012, code named “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

SQL Server Denali SSIS Enhancements Part 1 of 2

8 Enhancements in Integration Services 2012 for Easier Package Development

Variable enhancements in RC0 [SSIS]

Introducing SQL Server Data Quality Services, plus what’s new in SQL2012 SSIS

Upgrade 2005/2008 SSIS Packages to 2012 Like a Boss!

Video Managing SSIS in Denali

SQL Server Integration Services 2012 – Project Deployment Model

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.
This entry was posted in SQL Server 2012, SQLServerPedia Syndication, SSIS. Bookmark the permalink.