Long time developer however somewhat relative newbie to SSIS ( I've developed a few packages successfully)
After writing a file, I would like to execute a remote process passing the data file as input.
Additionally I would like to execute the remote process asynchronously and be notified when the process is complete.
What tools in SSIS might I look at to accomplish this task?
Execute Process Task calling powershell and run a command file?
Any direction would be helpful.
View Complete Post