SSIS Package fails under SQL Agent

  • I have several packages running under SQL Agent in SQL 2005, and all but one of them runs perfectly. The only difference in the one that fails is that it is puling data from an Excel spreadsheet instead of a legacy DB.

    I have logging set on, but nothing even comes through to my log file. The package will run fine in BIDS and in DTExec, but not under the SQL agent.

    I am at a loss. Anyone help me out?

     

    Thx

  • If you're running 64-bit check this thread:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=148&messageid=357285

    There are several threads dealing with the workaround needed for SQL Agent to run jobs requiring OLEDB providers which do not have a 64-bit version available (ie. Access and Excel do not have 64-bit providers).

  • Thx wyliec2 - i changed the job under the sql agent to run using the cmdexec property and it works fine.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply