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?

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 dtexec utility (dtexec.exe)

B.
SQL Server DTExecUI utility (dtexecui.exe)

C.
SSIS Upgrade Wizard in SQL Server Data Tools

D.
SQL Server Integration Services Deployment Wizard

Explanation:
Use the SSIS Package Upgrade Wizard to upgrade SQL Server 2005 Integration Services
(SSIS) packages and SQL Server 2008 Integration Services (SSIS) packages to the
package format for the current (2012) release of SQL Server Integration Services.



Leave a Reply 0

Your email address will not be published. Required fields are marked *