What should you use to execute the package?

Posted by: Pdfprep Category: 70-463 Tags: , ,

You develop and deploy a SQL Server Integration Services (SSIS) package.

The package is stored in the file system.

You need to execute the package without importing it to the SSIS server.

What should you use to execute the package? (Each correct answer presents a complete solution. Choose all that apply.)
A . catalog.start_package
B . dtexec
C . SQL Server Management Studio
D . SQL Server Agent

Answer: B, D

Explanation:

Explanation: http://technet.microsoft.com/en-us/library/ms141708(v=sql.110).aspx

Leave a Reply

Your email address will not be published.