Home Forums SQL Server 7,2000 SQL Server Agent Please Help Solve Why SSIS Package Fails When Run as SQL Agent Job RE: Please Help Solve Why SSIS Package Fails When Run as SQL Agent Job

  • fellmeth (1/19/2011)


    Thanks, Grasshopper. I'd forgotten about this post. I'll keep your solution in mind for the future. What I discovered a few weeks ago was that we'd been copying existing working packages and then modifying them for the new server. SSIS really does not like this copying and modifying. When we finally gave that up and rebuilt the packages from scratch, all the problems we were having vanished.

    Some things change. Some things never should. 😎