If you find the error message as shown below while import data from Excel files, to resolve this issue make it Run64BitRuntime as FALSE under project properties.
[Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.
No comments:
Post a Comment