Freigeben über

DTS_E_OLEDB_EXCEL_NOT_SUPPORTED : Resolved

  • Artikel

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 :
image

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

image

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