Post reply

Not creating a tab in Excel when the package is run through SQL Server Agent

  • March 6, 2009 at 2:34 am

    #201036

    Hi,

    I really have a frustrating issue.

    I have a package that creates different tabs in an Excel spreadsheet, and later it inserts specific data into specific tabs. This package is scheduled to run each night using SQL Server Agent

    When the package is run using BIDS, it runs through fine. No Errors or anything.

    When the package is run using SQL Server Agent I get the following errors:

    OnError,'server name','domain'\'user login','package name',{0AA7ECFB-D7AE-415F-87F3-E292E97723D8},{78146651-8A33-4B3E-8191-BB2B16D3476D},2009/03/06 11:10:44 AM,2009/03/06 11:10:44 AM,-1071636471,0x,SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

    OnError,'server name','domain'\'user login','Data Flow Task Name',{ff0a208a-0c1a-4ff2-a7d7-6fce4d7c03b2},{78146651-8A33-4B3E-8191-BB2B16D3476D},2009/03/06 11:10:44 AM,2009/03/06 11:10:44 AM,-1071636248,0x,Opening a rowset for "'Excel Tab Name'$" failed. Check that the object exists in the database.

    OnError,'server name','domain'\'user login','package name',{0AA7ECFB-D7AE-415F-87F3-E292E97723D8},{78146651-8A33-4B3E-8191-BB2B16D3476D},2009/03/06 11:10:44 AM,2009/03/06 11:10:44 AM,-1071636248,0x,Opening a rowset for "'Excel Tab Name'$" failed. Check that the object exists in the database.

    OnError,'server name','domain'\'user login','Data Flow Task name',{ff0a208a-0c1a-4ff2-a7d7-6fce4d7c03b2},{78146651-8A33-4B3E-8191-BB2B16D3476D},2009/03/06 11:10:44 AM,2009/03/06 11:10:44 AM,-1073450982,0x,component "Excel Destination" (417) failed the pre-execute phase and returned error code 0xC02020E8.

    It seems like it does not create certain Tabs in the Excel spreadsheet when it is run using SQL Server Agent, so when the Data Flow Task later tries to insert data into the Tab it complains that the tab does not exist.

    I have re-created the components and tasks that seem to be the culprits, but it did not really help.

    Has anyone else encountered this? Does anyone have a solution for me please. It is really driving me up the wall!

    Thanks in advance!

    Hesten-

  • March 6, 2009 at 4:33 am

    #954755

    Could it be a permissions issue with the SQL Agent service user?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • March 6, 2009 at 6:09 am

    #954800

    I doubt it.

    Everything else works.

    But thanx for the thought.

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

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