CLASS Not Registered - Excel 2007 Data Source (Not 64 Bit machine)
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?
October 28th, 2010 9:42am

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.
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2010 11:24am

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
November 9th, 2010 3:57pm

Hey Lee, I am stuck on the same issue. Did you figure out what caused it? Thanks!-Christopher Rathermel
Free Windows Admin Tool Kit Click here and download it now
December 10th, 2010 5:18pm

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
December 10th, 2010 6:42pm

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
Free Windows Admin Tool Kit Click here and download it now
December 10th, 2010 6:42pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics