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 B. SSIS Upgrade Wizard in SQL Server Data Tools. SQL Server Data Tools (SSDT) is the successor to BIDS in SQL Server 2012 and includes the SSIS Upgrade Wizard, which can open packages created in earlier versions (including 2008) and migrate them to the 2012 format-including converting VBA/VSA scripts to VSTA (.NET) scripts…

Configure and deploy SSIS solutions

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

ASSIS Upgrade Wizard in SQL Server 2008 BIDS
BSSIS Upgrade Wizard in SQL Server Data Tools
CSQL Server DTExecUI utility (dtexecui.exe)
DSQL Server dtexec utility (dtexec.exe)

How the community answered

(42 responses)

B
95% (40)
C
2% (1)
D
2% (1)

Explanation

SQL Server Data Tools (SSDT) is the successor to BIDS in SQL Server 2012 and includes the SSIS Upgrade Wizard, which can open packages created in earlier versions (including 2008) and migrate them to the 2012 format-including converting VBA/VSA scripts to VSTA (.NET) scripts. The SSIS Upgrade Wizard in SQL Server 2008 BIDS (A) cannot upgrade packages to 2012 format; it only upgrades to the 2008 format. DTExecUI (C) is a GUI wrapper for running packages, not a migration tool. The dtexec utility (D) is a command-line runner for packages-it executes them but cannot upgrade their format or scripts.

Topics

#SSIS upgrade#SQL Server Data Tools#package migration#BIDS

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice