Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
goodsolution
Starting Member
38 Posts |
 Posted - 2009-06-19 : 15:31:36
|
| I am working on Excell Macro, while i have given the connection string as Excel Macro in OLE DB data source, and i can preview the data from the macro file, when i am tryin to populate that data into a table, i am getting the following errors [OLE DB Source [2030]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Macro Connection" 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 "OLE DB Source" (2030) failed validation and returned error code 0xC020801C. Any one has any idea how to get rid of this error?-Thanks |
|
|
|
|
|
Excel macro connection issue