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

  • Hi all

    Not sure if any one is still having this issue but the one change below seemed to resolve the problem for me.


    *** NOTE - I did not have to make any changes to the job properties etc ****


    Follow below steps :

    1. Right click Solution

    2. Select properties

    3. Go to Debugging tab

    4. Set 64 Bit Run Time to False

    5. click Ok and close out

    6. Save package

    7. Deploy / run package as per normal

    Web site address if needed for above steps

    http://social.msdn.microsoft.com/Forums/en-NZ/sqlintegrationservices/thread/71cd55a0-b32d-4b2f-99c8-52d5e3d8cd7c

    Cheers

    Vani 🙂