SSIS - excel source error in BIDS - 2008
[Excel Source [528]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC00F9304.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Solution:
go to Projects > Properties > Debugging and change "Run64BitRuntime" to "False"
Showing posts with label SSIS Excel connection error. Show all posts
Showing posts with label SSIS Excel connection error. Show all posts
Thursday, February 3, 2011
Subscribe to:
Posts (Atom)
