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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.