locked
CLASS Not Registered - Excel 2007 Data Source (Not 64 Bit machine) RRS feed

  • 質問

  • First off, I am not running on a 64 bit machine.

    I keep getting the following error when I try to run a task that has an ODBC connection to an xlsx file on a SQL Server 2005 server using SQL Server Agent.

    Executed as user: ACCT02\ssc_emr_ra. ... 9.00.4035.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  7:29:39 AM  Error: 2010-10-28 07:29:42.63     Code: 0xC0202009     Source: RFC_Data_Load Connection manager "Excel ODBC Connection"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040154.  An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".  End Error  Error: 2010-10-28 07:29:42.63     Code: 0xC020801C     Source: Data Flow Task OLE DB Source [3052]     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel ODBC Connection" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.  End Error  Error: 2010-10-2...  Process Exit Code 1.  The step failed.

    I have tried running both as an Integration Services Task and as an Operating System task with the same result. The server does not have Office 2007 installed. Everything I see talks about the issues with running on 64 bit machines, which mine is not. The task runs correctly in development, just not when it is deployed to the server.

    What am I missing?

    2010年10月28日 13:35

回答

すべての返信

  • Try to install http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en

    "This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access 2007 (*.mdb and *.accdb) files and Microsoft Office Excel 2007 (*.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server. Connectivity to existing text files is also supported.

    ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.

    "

    Regards,

    Akim

     

     

    P.S. There were SPs released for these components - i'd recommend going with the latest.

    2010年10月28日 15:23
  • I'm sorry it took so long for me to test and respond. My server admin has indicated that the above components were installed. I am still getting the same error:

    Executed as user: ACCT02\ssc_emr_ra. ... 9.00.4035.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  1:49:39 PM  Error: 2010-11-09 13:49:47.07     Code: 0xC0202009     Source: RFC_Data_Load Connection manager "Excel ODBC Connection"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040154.  An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".  End Error  Error: 2010-11-09 13:49:47.07     Code: 0xC020801C     Source: Data Flow Task OLE DB Source [3052]     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel ODBC Connection" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.  End Error  Error: 20...  The package execution fa...  The step failed.

    Is there anything else I should be looking at, or is there a way to test that the above components were properly installed?

    Thanks,

    Lee

    2010年11月9日 20:56
  • Hey Lee,

    I am stuck on the same issue.  Did you figure out what caused it?

    Thanks!


    -Christopher Rathermel
    2010年12月10日 22:06
  • Chris,

     

    I followed what AkimZ suggested and it worked. Apparently the admin did not verify that it installed correctly the first time. I had them reinstall and now it works just fine.

     

    Lee

    2010年12月10日 23:36