?
Solved

SSIS - Excel connection manager

Posted on 2010-09-23
4
Medium Priority
?
850 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

762 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