Solved

SSIS - Excel connection manager

Posted on 2010-09-23
4
839 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
 
LVL 6

Expert Comment

by:dax_bad
ID: 33748299
0
 

Author Comment

by:VBdotnet2005
ID: 33748827
0
 

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

828 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