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 Integration Services Deployment Wizard
B.
SQL Server Configuration Manager
C.
SSIS Upgrade Wizard in SQL Server Management Studio
D.
SSIS Upgrade Wizard in SQL Server 2008 BIDS
Explanation:
You can upgrade packages that were created in earlier versions of Integration Services to
the Integration Services format that SQL Server 2012 uses. SQL Server provides the SSIS
Package Upgrade Wizard to help in this process. Because you can configure the wizard to
backup up your original packages, you can continue to use the original packages if you
experience upgrade difficulties.
You can run the SSIS Package Upgrade Wizard from SQL Server Data Tools (SSDT), from
SQL Server Management Studio, or at the command prompt.
Note:
* When you upgrade an instance of SQL Server 2005 or SQL Server 2008 to the current
release of SQL Server, your existing SQL Server 2008 Integration Services (SSIS) packagesare not automatically upgraded to the package format that the current release SQL Server
Integration Services uses. You will have to select an upgrade method and manually upgrade
your packages.