Using BIDS to upload excel file to SQL Server table

  • Thread starter PatFromWilloughby
  • Start date
P

PatFromWilloughby

I often use BIDS (2005) SQL Server Integration Services to upload text and
excel files into SQL Server 2005. However, I received an Excel file from an
external source, and when I try to upload it, I get the following error:

[Excel Source [1]] 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.

Can anyone help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Upload Center on Office 2010 when using encrypted area on disk 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
Question for WINSCP software and code for excel application currentlyusing FTP for uploading downloa 0
Path/File Access Close this error then Run-time '75' Error 0
Editing sql server data in Excel 2007 0
import Excel worksheet to SQL Server table 7

Top