Click here to Skip to main content
15,891,864 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All,

I need to execute a batch file MainProcess.bat through SSIS. The batch file content is as follows..

VB
echo off
cd G:\BatchProcess
cd

call file1.bat file2


In SSIS, I am using a Execute Process Task to run the batch file MainProcess.bat which is located at network drive G (C:\G\MainProcess.bat). This is used to download a file through FTP.

The arguments file1.bat and file2 needs to be passed through the SSIS as arguments. So I have created two variables
Var1 - file1.bat and Var2 - file2
and set the argument in Process task as
@[User:Var1] + " "+ @[User:Var2].

And I have modified the batch file as follows..
VB
echo off
cd G:\BatchProcess
cd

call %1


When I run the task I am getting the following error - error at ""

Please help.

Thanks in advance
Posted
Comments
Kuthuparakkal 4-Dec-12 4:51am    
Your batch file works or not ? Try to execute batch file from command window(cmd.exe)
SruthiR 4-Dec-12 5:02am    
yes it works. It downloads the file also.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900