I have 2 linked servers, each with their own SSIS packages. I wish to 'link' them so effectively I have one 'fire and forget' process as opposed to 3 separate 'parts' (which I'll have to schedule separately);
packet 1 (server 1) runs from a scheduled task,
On completion packet 2 is run (on server 2)
On completion packet 3 is run (on Server 1)
I've spent the morning trying to configure the xp_cmdshell option...but cannot get it working (I've added the permissions under the SA account for the account it's running in on the first server)
IS there an easier way to do this? I assume one of you Experts have encountered a similar issue before.
Any assistance would be gratefully received