Code: 0xC0202009 , SSIS Error Code DTS_E_OLEDBERROR

• msftlokhandwala

  SSC Veteran

  Points: 272

  More actions

  May 19, 2010 at 12:41 pm

  #235200

  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

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  May 20, 2010 at 3:00 am

  #1169948

  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

• msftlokhandwala

  SSC Veteran

  Points: 272

  More actions

  May 20, 2010 at 11:26 am

  #1170356

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