What should you use to execute the package?

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.)

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



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Error 0x80040E14

Error 0x80040E14

ooh! fell for that… knew it was B and SQL Server agent jobs being part of SSMS, I plumped for C, tricksy!

Ninja

Ninja

I also agree with Error. B & C.