5 Days of Building, Developing and Managing SQL Server

Friends of SQL Server, For Database Administrators, For IT Professionals

SQT06 What's New in SQL Server Integration Services 2012

12/11/2012

2:00PM - 3:15PM

Level: Intermediate

Kevin Goff

Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

SSIS has always been a good ETL product. In SQL Server 2012, SSIS got even better. Microsoft simplified certain ETL tasks to help new developers learn SSIS more quickly, and added new features that will be a hit to experienced ETL developers. In this presentation, I'll cover all the new features in SSIS 2012: parameters, new tasks, simplified tasks, new expression functions, data taps for dynamically "tapping" into a data flow pipeline, better handling of invalid metadata references, and a greatly improved deployment model. SSIS 2012 also uses the new SQL Server Data Tools interface (the Visual Studio 2010 shell). After participating in this presentation, you might very well agree with me that SSIS has gone from "good" to "great" in 2012.

You will learn:

  • Overall improved UI and workflow in SSIS 2012
  • The new SSIS project deployment model and the benefits
  • How to incorporate stored procedures and staging tables into ETL scenarios