Comparing and merging packages
Package formats have been given some consideration in this version of Integration Services, which now makes it easier to compare your packages. This neater XML format also gives you the ability to merge packages that do not have conflicting changes.
By using XML, the format allows for a separate element for each property and the attributes are listed in alphabetical order so it is easy to find and understand the settings. Properties that have a default value won't be listed, while elements that appear more than once are now contained within a parent element.
If you have objects in a package that can be referenced by other objects, which is usually most of them, you will find they have been given a RefID attributeather ...
Get What's New in SQL Server 2012 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.
