Home Forums SQL Server 2008 SQL Server 2008 Administration SSIS package failing while executing as Agent job RE: SSIS package failing while executing as Agent job

  • March 21, 2013 at 7:30 am

    #1599371

    lazy writer (3/21/2013)

    Thanks Welsh for your help.

    When I set the job to run package as 32 bit then it started working fine. 🙂

    Thanks John and every one.

    Glad that was it, it is always something like that, that gets me all the time! When ever I create a new package this is one of my first steps! Good luck! and don't forget to encrypt it if you are saving a user name and password or you will end up in the same boat!

    😀

    MCSE SQL Server 2012\2014\2016