SSIS run batch process from differnet server

Question

I have my SSIS package in server A and I want run a batach process in Server B,

Can this be possible in SSIS?

thanks

Answer 1

Maybe you could try running PSExec from sysinternals in an execute process task

Answer 2

you can use PSExec like SPE109 says, just be sure to set the -accepteula when calling it or it will just hang

Answer 3

You could also use WMI and the Win32_Process class from a Script Task. The WMI classes are located in the System.Management.dll assembly. There are many examples of doing this on the internet. Here are a couple:

http://www.codeproject.com/KB/cs/Remote_Process_using_WMI_.aspx

http://businessintelligencechronicles.blogspot.com/2009/05/ssis-script-task-to-monitor-if-remote.html