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
Explanation:
Ref: http://technet.microsoft.com/en-us/library/ms141708(v=sql.110).aspx
The right answer is letter B. dtexec.
you can you dtexec to execute package from SQL Server, SSIS service or File System.
https://technet.microsoft.com/en-us/library/ms162810(v=sql.105).aspx
B and D
check this https://docs.microsoft.com/en-us/sql/integration-services/packages/run-integration-services-ssis-packages
Correct. B and D. And thank you for your reference.
You could also use SQL Server Management Studio with the command:
XP_CMDSHELL ‘DTExec /F “packagelocation/package.dtsx”‘
Or would that still count as dtexec only?
for C. SQL Server Management Studio need to import it to the SSIS server. So ans is B and D