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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy