Monday, February 06, 2012 | |
SSIS Excel Connection Manager error
Location: BlogsRT-blog    
Posted by: Ron Smith 2/20/2009 3:51 PM

I have an integraiton package that I created in VS2005.  It has worked fine for many months.  I recently opened it to make some changes and all of my connecitons to an excel spreadsheet were throwing errors:
"The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code..."

I had recently installed VS2008 and other software -it could have been one of those causing the problem - it's hard to tell.

Turns out the solution is this:

  1. Open the properties of your integration project.
  2. In the Debugging section, change the value of "Run64bitRuntime" to false.

 

SSIS 2005
Sql Server 2005 Integration Services
VS2005
Permalink |  Trackback
Comments (7)   Add Comment
Re: SSIS Excel Connection Manager error    By rsmith on 2/20/2009 3:50 PM
Update: This continues to be a problem. I'm able to toggle the setting and save the project - sometimes that will get it working again, but not always. This is very frustrating - obviously something's wrong under the hood.
Re: SSIS Excel Connection Manager error    By rsmith on 3/13/2009 7:47 AM
Update: Still plagued by this issue. The workaround is to run the package from within SSIS instead of Visual Studio. Sigh
Re: SSIS Excel Connection Manager error    By Usman on 12/16/2009 8:05 AM
Thanks...it really helps me a lot...
Re: SSIS Excel Connection Manager error    By Sam on 10/12/2010 10:17 AM
Smith,<br><br>I am facing the exact error for importing excel files. What do you mean by <br>"run the package from within SSIS instead of Visual Studio". <br><br>Do you want me to run the package from SQL Server MSDB after installing the package there?<br><br>Any suggestion would be appreciated ?
Re: SSIS Excel Connection Manager error    By rsmith on 10/12/2010 10:18 AM
@Sam: Open SSIS, ,which is a part of MS SQL - you should be able to run the package.
Re: SSIS Excel Connection Manager error    By Sam on 10/12/2010 11:12 AM
Do you mean BIDS...but thats Visual studio again rite...Please can you elaborate that
Re: SSIS Excel Connection Manager error    By rsmith on 10/12/2010 11:15 AM
SQL 2005 - SSIS<br>http://msdn.microsoft.com/en-us/sqlserver/bb671393.aspx<br>It may be called something else in SQL 2008.<br>

Your name:
Title:
Comment:
Security Code
Enter the code shown above in the box below
Add Comment   Cancel 
Search
Archive
Copyright 2009 Real Technology | Terms Of Use | Privacy Statement Home | RT-Blog | Contact Us | About RT