The IT department is currently upgrading all SQL Server Integration Services (SSIS)
packages to SSIS 2012.
The final version of a complex SSIS 2005 package has been overwritten. Four prior versions
of the package exist. Each of the prior versions contains a different part of the final solution.
You have backups of all associated project files.
You need to create an updated package as quickly and accurately as possible.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
A.
Use an XML editing tool to merge the compatible changes of the package versions by
comparing the package refID fields. Upgrade the merged version.
B.
Upgrade the four package versions. Use an XML editing tool to merge the compatible
changes of the package versions by comparing the package refID fields.
C.
Use the DataSet.Merge method to merge the compatible changes of the package
versions by using the Lineage IDs. Upgrade the merged version.
D.
Upgrade the four package versions. Use SSIS Designer to visually compare the package
versions, determine the compatible changes, and copy the compatible tasks into a single
package.