CODEWITHSUNDEEP
ssis
Sreejesh Kumar
Sreejesh Kumar

Reputation: 2499

Package execution failed using DTEXEC /SQ

I have deployed a package through SQL Server Deployment to a Custom Folder "Folder1" under MSDB. The execution failed using DTEXEC. What is the correct syntax using DTEXEC ?

Upvotes: 0

Views: 634

Answers (1)

billinkc
billinkc

Reputation: 61249

dtexec utility 

dtexec /sql \Folder1\MyPackage /server MyServer

Note that for packages deployed to SQL Server, the file extension is not present while execution of a package on the file system would require the .dtsx extension.

Upvotes: 1

Related Questions