SQL Server 2012: Need to Execute Last Step on a Job on Another Server. How Do I Do This?

Techies--

I have one staging server which acquires and transforms data that I have in 2 ssis steps. I have another SSIS step which needs to be launched on a different server to finish the process.  Will that job step be able to know whether the remote SSIS job completed successfully?


  • Edited by ditallop Friday, September 11, 2015 7:55 PM
September 11th, 2015 6:22pm
Yes, you deploy the job that does work on another server, then you just call a package as a job step....
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2015 6:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics