O'Reilly logo

Microsoft® SQL Server® 2012 Integration Services by Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Team Development

Improvements in SQL Server 2012

This section describes some important changes that were made to SQL Server Integration Services in SQL Server 2012 to improve the overall team development experience for SSIS users.

Package Format Changes

SQL Server Integration Services packages are XML files with a .dtsx file extension. In previous versions of the product, this XML was verbose with very little formatting, which made it difficult to read without loading it in the SSIS designer. Significant changes were made to the SSIS package format in SQL Server 2012 to make the package XML easier to read and easier to “diff” (compare ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required