September 2012
Beginner to intermediate
672 pages
21h 25m
English
book
Microsoft® SQL Server® 2012 Integration Services
by Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam
Content preview from Microsoft® SQL Server® 2012 Integration ServicesBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...