I have BIDS running on my local machine, but am trying to create a package that will be posted on the Integration Services of my production server. In my package, I wanted to run a batch file that is stored on my Production server, but I can't figure out how to get it done. The data flows create 2 files and store them on the production server. The rename.bat file is supposed to rename the two files to include a timestamp and then the ForEach container/FTP Task combo is to take a copy of one of these files and upload it to another server in a different location.
I can get this all done when I have the rename.bat locally on my machine, but now that I'm trying to modify the package to work on the production server I can't get the rename.bat to work! I have put a copy of the rename.bat in the identical folder on the production server, but again, I'm running the BIDS locally, so the Execute Process Task runs the remote rename.bat as though it was on my local machine, and doesn't rename the files that are created on my production server.
How can I get this done? Thanks for all the help! :-)