Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SSIS - Excel connection manager

Posted on 2010-09-23
4
Medium Priority
?
855 Views
Last Modified: 2012-05-10
I am not sure what this error is all about. How can i correct it?  In Excel Destination Editor, everything look ok to me.

[Excel Destination [2457]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

[DTS.Pipeline] Error: component "Excel Destination" (2457) failed validation and returned error code 0xC020801C.
0
Comment
Question by:VBdotnet2005
  • 2
4 Comments
 

Accepted Solution

by:
VBdotnet2005 earned 0 total points
ID: 33749594
this helps.
http://forums.asp.net/t/1391496.aspx
"You can solve this issue by setting Run64BitRunTime property as False"
0
 

Expert Comment

by:irenetheodora
ID: 33750636
I think VBdotnet2005 is correct. If u run it in 32bit machine, excel files would work lovely. But if your machine is 64bit, u might wanna use csv or txt for the file format. Because even if it works with the quick fix VBdotnet2005 mentioned above, you won't be able to schedule the job since it will run base on 64bit machine and you'll stuck with the same error.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

810 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