Microsoft Exam Questions

Which tool should you use?

You maintain a SQL Server Integration Services (SSIS) package. The package was
developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS).
The package includes custom scripts that must be upgraded.
You need to upgrade the package to SQL Server 2012.
Which tool should you use?

A.
SQL Server Configuration Manager

B.
SQL Server Agent

C.
SSIS Upgrade Wizard in SQL Server Management Studio

D.
SQL Server DTExecUI utility (dtexecui.exe)

Explanation:
Use the SSIS Package Upgrade Wizard to migrate packages that were developed in SQL
Server 2005 Integration Services (SSIS) and SQL Server 2008 Integration Services (SSIS)
to the package format that the current release of Integration Services uses.
SSIS Upgrade Wizard (SSIS Package Upgrade Wizard)