DTS_E_OLEDB_EXCEL_NOT_SUPPORTED : Resolved

Today morning i was working with a SSIS package and came across this error while running the package through a SQL Agent Job on a 64 Bit WIn SRV 08 running SQL 08 SP1.

A little more about my dev environment:

My Dev machine is running a 64 bit Win 7 RC with 08 BIDS

My Production machine is running SQL 08 SP1 on Win 08 all 64 Bit.

What I am doing?

Creating a SSIS package to get some data stored in a Excel File (Office 2003 Format) on a remote share to my production warehouse.

What's the Error?

Simply put…

Executed as user: domain/Username. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  10:00:00 AM  Error: 2009-05-02 10:00:02.36     Code: 0xC00F9304     Source: PackageName Connection manager "Excel Connection Manager"     Description: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.  End Error  Error: 2009-05-02 10:00:02.36     Code: 0xC020801C     Source: Remote to Staging 1 Excel Source [521]     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC00F9304.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.  End Error  Error: 2009-05-02 10:00:02.38     Code: 0xC0047017     Source: Remote to Staging 1 SSIS.Pipeline     Description: component "Excel Source" (521) failed validation and returned error code 0xC020801C.  End Error  Error: 2009-05-02 10:00:02.38     Code: 0xC004700C     Source: Remote to Staging 1 SSIS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2009-05-02 10:00:02.38     Code: 0xC0024107     Source: Remote to Staging 1      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  10:00:00 AM  Finished: 10:00:02 AM  Elapsed:  1.857 seconds.  The package execution failed.  The step failed.

Why the error?

Excel Connection Manager is not supported on 64 bit runtime

How I resolved?

1. Open up the Agent Job >> Go to Steps :

2. Double click and Open the Step >> Go to Execution Options and Select Use 32 bit Runtime

You’re good to go.

Cheers!!

Comments

• Anonymous
  May 04, 2009
  PingBack from http://www.codedstyle.com/dts_e_oledb_excel_not_supported-resolved-2/

• Anonymous
  February 14, 2010
  Thanks a lot . such a simple solution neatly told.... worked perfectly... :)

• Anonymous
  May 12, 2010
  Thank you for this ticket. I solved the problem in executing single SSIS, bud i hav not seen the checkbox in Jobs. Thank you for that :-)

• Anonymous
  August 11, 2010
  The comment has been removed

• Anonymous
  August 11, 2010
  The comment has been removed

• Anonymous
  January 31, 2011
  thanks Man . it working 100%

• Anonymous
  March 17, 2011
  Thanks!!!!!!

• Anonymous
  May 31, 2011
  Thanks a lot, it works perfectly !

• Anonymous
  June 07, 2011
  Thanks !!!!!!!!!

• Anonymous
  January 11, 2012
  Thanks a lot; However if you are working in BIDS and this happems; Open the Project Properties; then under the Debugging properties set the "Run64BitRuntime" property to false

• Anonymous
  January 16, 2012
  Great Stuff! Thanks heaps for your posting and was put in very plain English!

• Anonymous
  February 22, 2012
  .. Or... From your BI Editor, select the project >> Properties. Under Debugging, Set False for Run64BitRunTime.

• Anonymous
  February 24, 2012
  Thanks¡¡¡ it works¡¡¡ :)

• Anonymous
  May 11, 2012
  Thanks Terry for the tip on how to get it to work in BIDS!  And great original post!

• Anonymous
  May 12, 2012
  Thanks a LOT friend, the solution is perfect..!!!!

• Anonymous
  June 19, 2012
  Thanks for this.  Saved me from pulling the rest of my hair out.

• Anonymous
  December 03, 2012
  Thanks a lot. It's perfect.

• Anonymous
  February 13, 2013
  saved my life thanks!!!!!!!!!!!!!!

• Anonymous
  July 03, 2013
  Thank, so much, perfect solution¡¡¡¡, best regard

• Anonymous
  August 27, 2013
  Thnx. Perfect:)

• Anonymous
  September 04, 2013
  Thank you for taking the time to post this solution.

• Anonymous
  October 10, 2013
  Thanks, I had been trying to find out the solution from so many days ....

• Anonymous
  February 09, 2014
  Thanks - worked a treat - much appreciated.

• Anonymous
  July 09, 2014
  thanks a ton . it worked like charm

• Anonymous
  September 04, 2014
  what a great solution ! thanks bro ..

• Anonymous
  September 08, 2014
  Thanks!!

• Anonymous
  October 26, 2014
  Wow thanks!!! Great Solution neatly told.

• Anonymous
  December 03, 2014
  Thanks it really helped :)

• Anonymous
  December 29, 2014
  Great. Terry/ Selva's tip really helped me to fix the issue in BIDS. Much appreciated friends.

• Anonymous
  February 03, 2015
  @Terry 12 Jan 2012 7:02 AM  - Thanks you save my day.!!! Thank you!!

• Anonymous
  October 02, 2015
  Wow..Great!!  Thnks for sharing

• Anonymous
  November 12, 2015
  PERFECT, THANKS!!

• Anonymous
  November 17, 2015
  Thanks man, this stupid setting resolve my epic issue :-P