Which tool should you use?

Correct Answer for the following Question is given below

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?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. Reference: SSIS Upgrade Wizard (SSIS Package Upgrade Wizard)

Question:

Which tool should you use?

Options:

SQL Server Configuration Manager

SQL Server Agent

SSIS Upgrade Wizard in SQL Server Management Studio

SQL Server DTExecUI utility (dtexecui.exe)

Correct Answer

The Correct Answer for this Question is

SSIS Upgrade Wizard in SQL Server Management Studio

Explanation

The Question – Which tool should you use? has been answered correctly and answers for the question is SSIS Upgrade Wizard in SQL Server Management Studio

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment