SSIS Execute Process Task is running Notepad instead of Bat file

Question

My Execute Process task runs fine from a XP machine.  When I move it to a Win7 machine, then the Execute Process task launches the bat file in Notepad instead with CMD.

Parameters-

RequireFullName = True

Executiable = D:\Apps\DailyGrinds\RadUnZip.bat

Arguments = zzz

FailTaskIfReturnCodeISNotSuccussValue = Fales

SuccessValue = 0

Timeout = 0

WindowStyle = Normal.

The bat file run just fine with done manually. Also, if I change the WindowStyle to hidden, then the task never completes (stays yellow)

So, why would the Execute Process task be launching Notepad?

Answer 1

It seems to be a file association issue, to overcome supply the full path to cmd exe to execute the BAT e.g.

Specify CMD.EXE as your executable and following line as arguments: /C D:\Apps\DailyGrinds\RadUnZip.bat ZZZ.

The arguments are passed to CMD.EXE which runs your command and handles the input/output redirection.

CMD.exe is %windir%\system32\cmd.exe

---

Arthur My Blog

Answer 2

Search google for it and find solutions like:
http://social.technet.microsoft.com/Forums/en/w7itprogeneral/thread/fc2ca91d-5509-4c9b-92a5-5af19375e361
http://help.lockergnome.com/windows/BAT-File-Association-Broken--ftopict514456.html

Alternative... rename it to .cmd

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter