70-463 · Question #48
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…
The correct answer is C. SSIS Upgrade Wizard in SQL Server Management Studio. 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.
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 Configuration Manager
- BSQL Server Agent
- CSSIS Upgrade Wizard in SQL Server Management Studio
- DSQL Server DTExecUI utility (dtexecui.exe)
How the community answered
(22 responses)- A5% (1)
- C91% (20)
- D5% (1)
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.
Topics
Community Discussion
No community discussion yet for this question.