none
SSIS Error Code DTS_E_OLEDBERROR

    Question

  • Hi

     

    when I ran the SSIS package through the SQL server Agent job I am getting the following error message. Could someone please let me know what it is?

     

    Can we use ODBC connection to run the SSIS packages instead of OLE DB connection?

     

    Message
    Executed as user: user name. ...0.3042.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  11:42:08 AM  Error: 2008-11-18 11:42:45.79     Code: 0xC0202009     Source: MasterAuto Connection manager "datasource"     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: 2008-11-18 11:42:45.83     Code: 0xC020801C     Source: Load Master Data Master_PBAT [1]     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "datasource" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.  End Error  Error: 2008-11-18 11:42:45.84     Code: 0xC00470...  The package execution fa...  The step failed.

    Tuesday, November 18, 2008 5:00 PM

Answers

  • This is very likely the case of executing a package that uses an OleDB provider that is registered on the 32 bit hive only. For example, you design a package to use Excel / Access sources. Everything is fine on your 32 bit dev box, but on the x64 server it fails (unless you specify that it needs to run in a 32 bit environment). Please take a look at http://msdn.microsoft.com/en-us/library/ms141766.aspx.
    Thursday, November 20, 2008 3:02 AM