Exception from HRESULT: 0xC020801C (Microsoft.SqlSErver.DTSPipelineWrap)

Asked By Carol K Simons 10 points N/A Posted on - 03/08/2013

While using Microsoft Visual Studio I am receiving this error message which showing that Class is not registered.

The whole message you can see in the below image.

What should I do now?

Any idea.

Microsoft Visual Studio

Error at Org_eenheden [Connection manager “Excel connection Manager”]: SSIS Error Code 

DTS_E_OOLEDB_Noprovider_Error. The requested OLE DB provider Microsfoft.ACE.OLEDB.12.0 is not 

registered. Error code: 0x000000000.

An OLE DB record is available. Source: “Microsoft OLE DB Service Components” Hresult: 0x80040154

Description: “Class not registered”.

Error at load data into SA [organisatie eenheden [1]]: SSIS Error Code

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call 

to the connection manager “Excel Connection Manager” Failed with error code 0xC0208302. There may be error 

messages posted before this with more information on why the AcquireConnection method call failed.

Additional information:

Exception from HRESULT: 0xC020801C (Microsoft.SqlSErver.DTSPipelineWrap)

• Status: Open
• Question Views: 6300
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Others

Answered By Spreckelmeyer Kayla 0 points N/A #175364

Exception from HRESULT: 0xC020801C (Microsoft.SqlSErver.DTSPipelineWrap)

Hello Carol,

While using Excel it’s a common error occurs due to multiple reasons. But most of the time it happens because of a simple reason. Most of the office product including excel provide 32 bits but we use 64 bits which excel does not provide and this is the reason behind the error.

To resolve this issue you just have to set the Run64BitRunTime property as False. That means for the overall SSIS solution you have to go to the property page at first then simply set the Run64BitRunTime = False.

I hope you can solve your problem in this way.

About Spreckelmeyer Kayla

Questions
1

Answers
135

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 03/18/2013
• Question Category: Microsoft Others