How to Run .Bat File From SSISPosted: September 7, 2012
I have a bat file to use Robocopy to move files. I setup a schedule with the native windwons scheduler and it worked pretty well. Howerver, I ran into an issue with clustering for synchronize both machines for the schedule in case of a failover. I dedcided to move the schdule to run an SSIS package.
Here are a few simple settings to setup the SSIS package to run a .bat file which includes my Robocopy command.
The key part is to use an Execute Process Task with the following settings for the simple package:
Within Execute Process Task Editor and under Process to fill in the following: