70-463 · Question #208
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 t
The correct answer is C. SSIS Upgrade Wizard in SQL Server Data Tools. 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.
Question
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?
Options
- ASQL Server dtexec utility (dtexec.exe)
- BSQL Server DTExecUI utility (dtexecui.exe)
- CSSIS Upgrade Wizard in SQL Server Data Tools
- DSQL Server Integration Services Deployment Wizard
How the community answered
(55 responses)- A2% (1)
- B4% (2)
- C95% (52)
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.
Topics
Community Discussion
No community discussion yet for this question.