• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1112
  • Last Modified:

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_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

===============================

 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_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  
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
==============================================================================
0
Ed
Asked:
Ed
  • 2
  • 2
1 Solution
 
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
Hi, Could you check that both connection object are OLE DB ?
if not, Please try to modify to OLE DB.



0
 
EdAuthor Commented:

Yes, both both connection object are OLE DB
0
 
ziolkoCommented:
"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.

0
 
EdAuthor Commented:

how do i install reinstal MDAC components on windows server 2003?
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now