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 ...

Get Microsoft® SQL Server® 2012 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.