Hi All, I have SSIS package which contains execute process task which calls bat file. The bat file contains the below code. In execute process task, i have selected this filename(C:\StartStopPublication\ICRV_STOP.bat) as executable. @echo off :Begin setlocal SET CLASSPATH=C:\Program Files\Java\jdk1.7.0_03\lib;C:\StartStopPublication\lib; @echo off java -Djava.ext.dirs=./lib/ StartStopPublication ogrdsdevuser ogrdsdevpwd Stop CA1 ICRV >MessageID.txt exit 0 Iam trying to call batch(.bat) file from SSIS of executeProcess task. But The batch file is not triggered when i tried to execute this package. If SSIS execute process task calls this batch file which can write a messageID into text file, it is not happening. if i run this batch file from command prompt, it is working fine. Could you please suggest me what i did wrong here.Thanks & Regards, Anil

Hi Anil.. Have you tried running the batch in command prompt.. Check whether the batch is executing from command.. I believe there will be some error with your batch file itself..

Hi, I have tried running the batch from command prompt and its working fine. i guess am doing wrong in ssis... Thanks & Regards, Anil

How did you configure the Execute Process Task? What happens when you run the package? Is there an error?MCTS, MCITP - Please mark posts as answered where appropriate.

1) Are you running it as a Job or within BIDS? 2) When you run it from the command prompt, did you run it as admin?Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Hi, Configured execuatable as "C:\StartStopPublication\ICRV_STOP.bat" and this package running successfully without errors.but the text file is not updated. It seems the batch itself not called from ssis. These all are doing in BIDS. iam connecting a remote pc with my credentials and the batch file created with my user. i am not admin user..executing with my credentials as this user is owner of batch file. This batch file executing fine when i ran it from commandprompt. Thanks & Regards, Anil

Hi anil yaaram, All seems ok, I suggest you implementing Logging in Packages to see what happens when run-time events occur. For more information about it, please see: http://msdn.microsoft.com/en-us/library/ms138020(v=sql.105).aspx Here is a thread has detail steps about configuring Execute Process Task to run bat file, please take it as reference: http://technet.microsoft.com/en-us/library/ms141166.aspx Thanks, Eileen