April 28, 2009 at 9:01 pm
HI,
I get the following error when trying to execute a job containing an SSIS task that uses MS Excel as a datasource.
The server is 64bit.
Executed as user: HNEAHS\username ...00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:42:42 AM Progress: 2009-04-29 11:42:43.06 Source: Import xls Validating: 0% complete End Progress Progress: 2009-04-29 11:42:43.08 Source: Import xls Validating: 50% complete End Progress Error: 2009-04-29 11:42:43.22 Code: 0xC0202009 Source: Westpac Connection manager "Excel Connection Manager" 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: 2009-04-29 11:42:43.22 Code: 0xC020801C Source: Import xls Westpac excel file [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "E... The package execution fa... The step failed.
I assume the problem is related to the task trying to find 32 bit drivers on the 64 bit server, or vice versa.
Do you have any thoughts what the problem may be?
April 29, 2009 at 12:59 am
There are no 64-bit OLEDB drivers for Excel.
You can normally get around this on a 64-bit machine by executing the package with the 32-bit version of dtexec - typically found in \Program Files (x86)\Microsoft SQL Server\90\DTS\Binn.
see this post for more detail:
April 29, 2009 at 4:28 pm
Hi,
Thanks for your reply.
I am investigating this avvenue, however my server admin cannot seem to find the DTSexec executable on the server as yet. I am hoping he is making a typo.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply