I have a SSIS package that simply retrieves the data from an Excel data source and copies it to a SQL Server table. Everything is set up and ready to run, except for two fields. I've spent too much time trying to figure out why these two fields will not work. I get the following error on the lookup component:
Error 1 Validation error. Data Flow Task | SSIS_TicketReviewRawData_9802: Lookup [23209]: output column "Call Skill" (25260) and reference column named "Call Skill" have incompatible data types. SSIS_TicketReviewRawData_9802.dtsx 0 0
I have deleted a couple of the components the package uses and re-created them. I have changed the data types of the fields in the SQL Server table as well as the data conversion component. I have also added "IMEX=1" to the Excel data source connection string. I can't think of any other way to solve this issue.
The fields are small numeric, with numbers ranging from around 0 - 20. If anyone could help me with this problem, I would GREATLY appreciate it, as my patience with this issue has run up.