blossompark
asked on
Running an SSIS package from a bat file
Hi,
I can run an SSIS package from the command prompt using the following command;
What is the syntax I need to put in the batch file?
Any guidance appreciated
Thanks
I can run an SSIS package from the command prompt using the following command;
c:\Program Files\Microsoft SQL Server\100\DTS\Binn>dtexec.exe /f c:\batch\writeSuccesWhenPackageFails.dtsx
I now need to call this package from a batch file.What is the syntax I need to put in the batch file?
Any guidance appreciated
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome, glad we were able to help.
~bp
~bp
Glad to help :)
ASKER
Thanks for your comments
Below worked perfectly.
@echo off
"c:\Program Files\Microsoft SQL Server\100\DTS\Binn\dtexec
PAUSE