January 13, 2011 at 5:52 am
Hi, i have an SSIS package that selects data from a table in the database and exports it to an Excel s/sheet, but it is failing with the following error :
[font="Courier New"]Error: 2011-01-13 12:29:12.06
Code: 0xC0209303
Source: Daily Snapshot Connection manager "Microsoft Excel 97-2000"
Description:
SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.
The requested OLE DB provider MICROSOFT.JET.OLEDB.4.0 is not registered -- perhaps no 64-bit provider is available.
An OLE DB record is available.
Source: "Microsoft OLE DB Service Components"
Hresult: 0x80040154
Description: "Class not registered".
End Error
Error: 2011-01-13 12:29:12.06
Code: 0xC020801C
Source: IEU OLE DB Destination [43]
Description:
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "Microsoft Excel 97-2000" failed with error code 0xC0209303.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.[/font]
Any ideas would be most welcome, thanks.
Mark Davies.
January 13, 2011 at 6:32 am
Are you running the package from BIDS?
Make sure the Run64BitRuntime property is set to False.
(right-click on project, select properties, look in the debugging pane)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 13, 2011 at 6:38 am
Hi, many thanks for the info., i am running the SSIS package from a Scheduled Job on a SQL 2008 server.
Can i specify wether to use, or not use 64-bit from within the Job ?.
January 13, 2011 at 7:42 am
MARKDSQL (1/13/2011)
Hi, many thanks for the info., i am running the SSIS package from a Scheduled Job on a SQL 2008 server.Can i specify wether to use, or not use 64-bit from within the Job ?.
Sure you can.
When you specify the SQL Server Integration Services jobstep, there is a tab "Execution Options".
There you have a checkbox Use 32 bit runtime.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 13, 2011 at 7:49 am
That sorted it, thanks very much.
January 13, 2011 at 8:54 am
MARKDSQL (1/13/2011)
That sorted it, thanks very much.
No problem, glad to help and that it worked out.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply