Run a SSIS Package Using Batch File

Question

need some help in executing my SSIS package from command prompt. below is the path of my DTExec file and the package path. when i run this , i am getting an error "missing argument for option "file"

"C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\DTExec.exe"/f

"C:\Users\myname\Documents\Visual Studio 2015\Projects\SSIS tutorials\SSIS tutorials\filtering duplicates using fuzzy grouping.dtsx"

please help

Is the dtexec.exe invocation followed by the dtsx filename on the same line? — criticalfix, May 02 '17 at 19:30
@Ramya have you tried the provided answer, if so i am waiting for a reply to give more help — Hadi, May 07 '17 at 20:55

score 0 · Answer 1 · answered May 02 '17 at 21:17

When installed Integration Services the DTExec path (C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\) is added by default to PATH environment variable so you can use the following command (make sure it is one line command)

Dtexec /f "C:\Users\myname\Documents\Visual Studio 2015\Projects\SSIS tutorials\SSIS tutorials\filtering duplicates using fuzzy grouping.dtsx"

Also check spacing between arguments

Reference

dtexec Utility (SSIS Tool) TechNet article

score 0 · Answer 2 · answered Mar 08 '19 at 14:53

0

I was able to resolve my issue by placing everything on one line as criticalfix and Hadi mentioned above. Make sure there are no returns after the /f argument, just a space.

answered Mar 08 '19 at 14:53

James Vaughn III

145
1
3
11

Run a SSIS Package Using Batch File

2 Answers2