Steve0

Executing SSIS Packages with a Windows Agent?

Discussion created by Steve0 on Jul 19, 2016
Latest reply on Jul 19, 2016 by Steve0
We finally got buy-in from the DBA's that they wanted to start using Automic for their jobs. I recently installed a SQL agent on one of the Windows servers in that tier and started thinking about if this was the right approach.. I was thinking that maybe I should install a Windows agent and have the agent execute the SSIS package on the server and monitor it for return codes which could dictate future actions.. 

Does anyone have experience with automating the execution of SSIS packages and verifying they worked correctly? 

Outcomes