Use SSIS to Run Exe on Remote Machine

[thermidor]

Hi All:

Can someone tell me if it is possible to use SSIS to run an executable on a remote machine, and if so how?

For example, if I am running SSIS on MachineA, how can I run an executable on MachineB?

Thanks,
Sven

 

[mrdenny]

You would need to use a remote scheduler to launch the app on Machine B. You can use the AT command line app to launch the app on the remote machine.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[CORIKIL]

We just ran across this and started using SSIS to call WMI on the remote machine

 

[thermidor]

Can you provide some detail how you did that?