• Ah so it's SSIS.

    To be honest with you, problems with deployment don't happen so often - as long as the account doing the deployment has permissions to deploy packages to your server and the server you are deploying to has an SSIS instance and is switched on then you'll be fine.

    Errors in running a package are far more common. Steps to troubleshooting that (depending on how you are executing) could include looking at the SQL Agent history, looking at the ssislog table (if you have set it up) or simply screaming an offensive word at the computer 😀

    I would recommend you set up your own logging of events in any packages that you have. Check out this article for tips on how to go about doing that.


    I'm on LinkedIn