View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PatFromWilloughby PatFromWilloughby is offline
external usenet poster
 
Posts: 1
Default Using BIDS to upload excel file to SQL Server table

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?