Home Forums SQL Server 2005 Administering ssis package not working with sql server agent but run fine manually RE: ssis package not working with sql server agent but run fine manually

  • September 27, 2012 at 7:07 am

    #1542860

    Hi,

    Try checking all logins you are using throughout the whole process, including all services accounts.

    In the jobs list, take a look at the history. Maybe that will give more idea on whats going on.

    Goodluck.


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort