Hey everyone! Welcome back to SQL Something!
Before the month is up (and I apologize for missing last month) let's get in a quick post. This time we look at a simple SSIS validation error: "
SSIS Excel Destination Failed Validation And Returned Error Code 0xC020801C".
This little guy popped when I attempted to export data to an Excel Destination in SSIS:
 |
| Fig. 1: Final Destination |
Looking up the error code can yield the following: "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.".
The error was produced because excel does not have a 64 bit driver. If your OS is 64 bit, SSIS will, by default, attempt to run all drivers as 64 bit. It is simply a matter of going to the project properties and changing the Run64BitRuntime property to FALSE:
 |
| Fig. 2: Finding Properties |
 |
| Fig. 3: Make the change to FALSE |
And that's all there is to it. :-)
DISCLAIMER: As stated, I’m not an expert so please, PLEASE feel free to
politely correct or comment as you see fit. Your feedback is always
welcomed. :-)
