Run a SSIS Package Using Batch File

ssis dtexec
Data Enthusiast picture Data Enthusiast · May 2, 2017 · Viewed 8.1k times · Source

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

Answer

Hadi picture Hadi · May 2, 2017

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

Related questions

calling SSIS package with input parameters on stored procedure

I have SSIS packages that is expecting an input parameter ID(integer). I need to execute this SSIS package using stored procedure so that I can pass the value of the ID. DECLARE @Command varchar(1000) , @PackageLocation varchar(1000) , @PackageName varchar(1000) , @XmlID …

Read More
dtexec error - setting multiple variables

Am trying to execute SSIS package with dtexec command line utility. my syntax for dtexec is as follows: dtexec /FILE "C:\DirectLoads\RefEDWDirectLoads.dtsx" /Set \Package.Variables [User::SourceDirectory].Properties[Value];"C\Test" /Set \Package.Variables [User::EDWConnection].Properties[Value];"…

Read More
Is it possible to pass parameters to a .dtsx package on the command line?

I am currently executing an SSIS package (package.dtsx) from the command line using Dtexec. This is as simple as: dtexec /f Package.dtsx However, I have some parameters that I would like to pass to the package for it …

Read More