Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > SQL SERVER (TECHNET) > AcquireConnection error 0xC0202009 - Excel Source error 0xC020801C
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 23rd September 11:55
michael roedeske
External User
 
Posts: 1
Default AcquireConnection error 0xC0202009 - Excel Source error 0xC020801C


Hello,

SSIS 2005 EE x64, I created an Excel connection 97-2005 within the
connection manager and mapped it to an excel source. After the source is a
data conversion ending in an SQL Server destination. When I execute the data
flow in the BIDS I get the follwing error:

[Excel Source [431]] Error: The AcquireConnection method call to the
connection manager "Modell_Suffix_ZuO Internet" failed with error code
0xC0202009.

[DTS.Pipeline] Error: component "Excel Source" (431) failed validation and
returned error code 0xC020801C.

Any ideas?
  Reply With Quote


  sponsored links


2 23rd September 11:56
allan mitchell
External User
 
Posts: 1
Default AcquireConnection error 0xC0202009 - Excel Source error 0xC020801C


Hello Michael,

There is no 64 bit Excel driver so you may need to "downgrade" BIDs

Have a look in the project properties (Right click on project in Solution
Explorer)

Now look in Debugging and look at the Run64BitRuntime property. Change this
to False

Allan
  Reply With Quote
3 23rd September 11:56
michael roedeske
External User
 
Posts: 1
Default AcquireConnection error 0xC0202009 - Excel Source error 0xC020


Dear Allan,

thank a lot, now it works that way!

Michael
  Reply With Quote
4 18th November 01:26
patyb
External User
 
Posts: 1
Default AcquireConnection error 0xC0202009 - Excel Source error 0xC020


Do you know when this will be resolved? We got a pretty big project with a
few Excel imports, and having to have people open Excel and save as .csv is a
pain.
And going down to 32 bits is going to hurt the performance of the whole
project.
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666