I have server A with SSIS running and an executable file in server B. I need to run this executable file from SSIS.
I tried with PsExec and managed to run the executable from server A. But, I need to execute this from SSIS and have no idea how to do it from SSIS or incorporate PsExec with SSIS.
You can simply run this executable using the Execute Process Task.
Just copy the PsExec command you used into the Executable property in the Execute Process Task editor. Or you can put PsExec into the Executable property and the rest of the command into the Arguments property.
You can learn more about this control in the following article:
