Microsoft
70-463 · Question #8
70-463 Question #8: Real Exam Question with Answer & Explanation
The correct answer is B: dtexec. This question tests which tools can execute an SSIS package stored on the file system without first importing it into the SSIS catalog.
Question
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.)
Options
- Acatalog.start_package
- Bdtexec
- CSQL Server Management Studio
- DSQL Server Agent
Explanation
This question tests which tools can execute an SSIS package stored on the file system without first importing it into the SSIS catalog.
Common mistakes.
- A. catalog.start_package is a stored procedure in the SSISDB catalog and can only execute packages that have been deployed to the catalog, not file system packages.
- C. SQL Server Management Studio's SSIS execution interface in the Object Explorer requires the package to be imported into the SSIS catalog (SSISDB); it cannot directly execute arbitrary file system packages.
Concept tested. Executing SSIS packages from the file system without catalog import
Community Discussion
No community discussion yet for this question.