Code: 0xC0202009 , SSIS Error Code DTS_E_OLEDBERROR

  • The package runs fine on my system but when I have it scheduled on the server its throwing an error.

    The package populates data into an excel sheet and text file from a MS SQL Server database table.

    Executed as user: AD-ENT\wssasmecp. ...cute Package Utility Version 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:49:33 AM Error: 2010-05-19 10:49:39.47 Code: 0xC0202009 Source: HBS_HSA_Employer_Survey_Package Connection manager "Excel Connection Manager 9" 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: 2010-05-19 10:49:39.47 Code: 0xC020801C Source: Populate data in Excel and Text Files Excel Destination [35] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 9" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireC. The step failed.

    Any help would be greatly appreciated

  • Try running the package in 32-bit mode. 64-bit and Excel gives problems.

    If it still fails, let us know.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • thanks it worked... had to use 32 bit compatible DTExec Utility

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply