You are developing a SQL Server Integration Services (SSIS) package. The package is stored as the myPackage.dtsx file in the root directory of the C drive of the SSIS server. You need to run the…

The correct answer is C. dtexec/f "C:\myPackage.dtsx". The dtexec utility uses the /f (or /File) switch to execute a package stored on the file system, followed by the full path to the .dtsx file. 'dtexec /f "C:\myPackage.dtsx"' is the correct syntax for a package located at C:\myPackage.dtsx. Option A uses /sql, which is for…

Configure and deploy SSIS solutions

Question

You are developing a SQL Server Integration Services (SSIS) package. The package is stored as the myPackage.dtsx file in the root directory of the C drive of the SSIS server. You need to run the package from the command prompt. Which command should you use?

Options

Adtexec/sql myPackage
Bdtexec/d "C:\File System\myPackage.dtsx"
Cdtexec/f "C:\myPackage.dtsx"
Ddtexec/com "myPackage.dtsx"

How the community answered

(33 responses)

B
3% (1)
C
94% (31)
D
3% (1)

Explanation

The dtexec utility uses the /f (or /File) switch to execute a package stored on the file system, followed by the full path to the .dtsx file. 'dtexec /f "C:\myPackage.dtsx"' is the correct syntax for a package located at C:\myPackage.dtsx. Option A uses /sql, which is for packages stored in a SQL Server msdb database (not the file system). Option B uses /d, which is not a valid dtexec switch for file-system packages. Option D uses /com, which is not a valid dtexec switch at all.

Topics

#dtexec#command prompt#package execution#file system path

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice