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

Asked By 10 points N/A Posted on -
qa-featured

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.

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

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)

SHARE
Answered By 0 points N/A #175364

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

qa-featured

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

Unhandled exception in the designer and has been disabled.

Previous

Microsoft Visual Studio I received an error message

Next

Related Questions