none
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

    Question

  • Hi all,

    I am getting the below error when i am running SSIS package from query analyzer.

    Microsoft (R) SQL Server Execute Package Utility
    Version 9.00.3042.00 for 32-bit
    Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
    NULL
    Started:  10:06:55 PM
    Progress: 2009-01-20 22:07:26.67
       Source: Data Flow Task
       Validating: 0% complete
    End Progress
    Progress: 2009-01-20 22:07:26.75
       Source: Data Flow Task
       Validating: 50% complete
    End Progress
    Error: 2009-01-20 22:07:27.11
       Code: 0xC0202009
       Source: frd Connection manager "faq"
       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: 2009-01-20 22:07:27.11
       Code: 0xC020801C
       Source: Data Flow Task OLE DB Source [579]
       Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "faq" 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: 2009-01-20 22:07:27.11
       Code: 0xC0047017
       Source: Data Flow Task DTS.Pipeline
       Description: component "OLE DB Source" (579) failed validation and returned error code 0xC020801C.
    End Error
    Progress: 2009-01-20 22:07:27.11
       Source: Data Flow Task
       Validating: 100% complete
    End Progress
    Error: 2009-01-20 22:07:27.11
       Code: 0xC004700C
       Source: Data Flow Task DTS.Pipeline
       Description: One or more component failed validation.
    End Error
    Error: 2009-01-20 22:07:27.11
       Code: 0xC0024107
       Source: Data Flow Task
       Description: There were errors during task validation.
    End Error
    DTExec: The package execution returned DTSER_FAILURE (1).
    Started:  10:06:55 PM
    Finished: 10:07:27 PM
    Elapsed:  31.5 seconds
    NULL

    Even i am using 32 bit path to run the package. I can run the package successfully through visual studio 2005 and execute package utility. Anyone please help me.

    Thanks.
    Wednesday, January 21, 2009 1:19 PM

All replies