| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Upload from Excel to SQL Server | Excel Discussion (Misc queries) | |||
| Data Upload from Excel to SQL Server | Excel Worksheet Functions | |||
| Data Upload from Excel to SQL Server | Links and Linking in Excel | |||
| How do I upload an Excel template file onto my Windows Smartphone | Excel Discussion (Misc queries) | |||
| How do I automate upload of data from one excel file to another? | Excel Worksheet Functions | |||
Linear Mode
