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 currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in SQL Server 2012, SQLServerPedia Syndication, SSIS. Bookmark the permalink.

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

  1. Pingback: SQL Server "Denali": CTP3 now available! | James Serra's Blog

  2. Pingback: BISQL #23 :SQL Server “Denali”: CTP3 now available !! « SQL Server Mentalist

  3. Pingback: Jumping from SSIS 2008 to SSIS 2012 | James Serra's Blog

  4. Pingback: SQL Server 2012: New Business Intelligence features | James Serra's Blog

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>