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

Show Hint

Leave a Reply 2

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

Greeny

Greeny

SQL Server Management Studio also supports execution of package stored in file system

Reply

ryahan

ryahan

@greeny , No However, you can import a package to the SSIS Package Store from the file system.

Reply