SSIS Trying to Import Excel Spreadsheet Fails With Error
Hi, 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? TIA
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.