Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to make work around for SSIS "Excel Connection Manager is not supported" error msg in SQL Server 2008

Posted on 2010-11-16
2
Medium Priority
?
1,870 Views
Last Modified: 2012-05-10
I'm using SSIS in a 64 bit environment (Visual Studio 2008/SQL Server 2008) and the package failed at the Excel Source control saying  "The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available."
Is there a work around or could I use an OLE DB Source instead of Excel Source for this package?


SSIS package "Section1.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC00F9304 at Section1, Connection manager "Excel Connection Manager":
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.
Error: 0xC020801C at Data Flow Task, Excel Source [152]: 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.
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "Excel Source" (152) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.
SSIS package "Section1.dtsx" finished: Failure.
0
Comment
Question by:EdZeppelin
2 Comments
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34153113
You may be able to use the ACE driver. I know this works on 64bit SQL Server using a linked server to all versions of Excel. So it should work with SSIS too.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d
0
 
LVL 2

Accepted Solution

by:
MKnauer earned 1000 total points
ID: 34153314
You could try to executing it as 32bit package..

"In the Project Properties of an Integration Services package, you can select 32-bit or 64-bit execution by setting the value of the Run64BitRuntime property on the Debugging page."
Source: http://msdn.microsoft.com/en-us/library/ms141766.aspx

=> In "BI Development Studio" (Visual Studio) Right-click on the project -> Properties -> "Debugging"

HTH,
Martin
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question