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
B, D
https://technet.microsoft.com/en-us/library/ms141708.aspx
0
0
ooh! fell for that… knew it was B and SQL Server agent jobs being part of SSMS, I plumped for C, tricksy!
0
0
I think Error is right
https://msdn.microsoft.com/en-us/library/hh231187(v=sql.110).aspx#Anchor_6
0
0
I also agree with Error. B & C.
0
0