August 19, 2010 at 9:10 am
Hi folks
I am getting this error while i was trying to run SSIS Package using VisualStudio and another third party tool.
While i am running this in VS2005 by chaining the debugging property Run64bit to false it is working fine
Not sure how to overcome this while running the packages through Control M scheduler
Please see the error
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".
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "NORMAN" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Please help!
May 4, 2011 at 3:13 am
May be you've set the Transaction Option as 'Required' at the package level. Make it to 'Supported'. This may eliminate the error.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply