Thank you Erland for your input. We do use linked servers in our environment and this was something that I had not checked, but upon doing so, I found...

Indeed, it is a DTS package; a legacy item from SQL2k that has yet to merit enough priority to migrate... maybe this issue will help to elevate that priority! 😉

Actually, the package connections in this case, had already been changed to point to production, in preparation for deployment; but to answer your question, I'm not afraid as the ability...

I am betting that the domain account for your SQL Agent will bring success to your jobs as it did mine, but if you are like me, you will probably...

I also have been fighting this fight. Originally experiencing what many others as well are seeing; package runs fine when 'right clicked', but fails when run from SQL Server...