ExecuteProcessTask is not calling bat file?

Question

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

Answer 1

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..

Answer 2

Hi,

I have tried running the batch from command prompt and its working fine.

i guess am doing wrong in ssis...

---

Thanks & Regards, Anil

Answer 3

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.

Answer 4

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

Answer 5

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

Answer 6

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