I created a Data Flow Task, added an Excel Source into the task and configured to point to the Excel spreadsheet source. Added an OLE Destination and joined the source to the destination. Upon trying the execute the task it fails with the following error:
Error: 0xC020801C at Data Flow Task, Excel Source : SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 2" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Has anyone seen this error before or have an ideas why it maybe failing?
asked Jan 22, 2015 at 05:25 PM in Default
David 2 1
Project >> Properties >> Configuration Properties >> Debugging and changed Run64BitRuntime to False resolved my issue.
answered Jan 22, 2015 at 05:45 PM
David 2 1
This issue is occuring because you are having a 64 bit OS and Office Excel (including most of the office products) does not have 64bit provider and hence the error above on Excel connection.
You can solve this issue by setting Run64BitRunTime property as False
Go to properties page for the overall SSIS solution, simply set the Run64BitRunTime = False.
answered Mar 21, 2016 at 08:42 AM