Ed
asked on
SQL Connection Manager
I've got an SISS package which runs fine when I execute it manually.
When I try to run it fom command line or from a job I get a connection manager error message which I have copied in below. The main error message is below . Does anyone know what might cause this?
Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
End Error Error: 2007-08-01 09:56:27.97 Code: 0xC020801C Source: Data Flow Task Source 6 - qryOCTMatrix [484]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECT IONFROMCON NECTIONMAN AGER
========================== =====
Source: ed_test2_import_live Connection manager "C:\CommTrak\CommTrakPort. accdb"
Description: 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".
End Error Error: 2007-08-01 09:56:27.97 Code: 0xC020801C Source: Data Flow Task Source 6 - qryOCTMatrix [484]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECT IONFROMCON NECTIONMAN AGER.
The AcquireConnection method call to the connection manager "C:\CommTrak\CommTrakPort. accdb" failed with error code 0xC0202009.
There may be error messages posted before this with more information on why the AcquireConnection method ...
The package execution fa... The step failed.,00:00:01,0,0,,,,0
========================== ========== ========== ========== ========== ========== ==
When I try to run it fom command line or from a job I get a connection manager error message which I have copied in below. The main error message is below . Does anyone know what might cause this?
Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
End Error Error: 2007-08-01 09:56:27.97 Code: 0xC020801C Source: Data Flow Task Source 6 - qryOCTMatrix [484]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECT
==========================
Source: ed_test2_import_live Connection manager "C:\CommTrak\CommTrakPort.
Description: 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".
End Error Error: 2007-08-01 09:56:27.97 Code: 0xC020801C Source: Data Flow Task Source 6 - qryOCTMatrix [484]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECT
The AcquireConnection method call to the connection manager "C:\CommTrak\CommTrakPort.
There may be error messages posted before this with more information on why the AcquireConnection method ...
The package execution fa... The step failed.,00:00:01,0,0,,,,0
==========================
ASKER
Yes, both both connection object are OLE DB
"Class not registered" is standard COM error meaning you're trying launch or access COM library that is not registered with regsvr32 or your dcomcnfg security settings don't allow you to do so.
try to reinstal MDAC components
ziolko.
try to reinstal MDAC components
ziolko.
ASKER
how do i install reinstal MDAC components on windows server 2003?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if not, Please try to modify to OLE DB.