SSIS Lookup give no match always for Oracle OLEDB connection

user_1841340 0
Viewed 36

I have flat file data source and Oracle Destination. When I use lookup transformation to validate some data exists in certain tables, it always gives no match. I have converted the data type in derived column, it exactly matches with the table data type. Data type of the column is Unicode string. Exact matches leads to no match output. I am using native SSIS OLEDB connection for Oracle. Please help.

enter image description here

enter image description here

enter image description here

etl data-migration ssis lookup oracle
1 Answers

Check your case sensitivity. Sreekanth will not match sreekanth or SREEKANTH

Check for trailing spaces, even in variable length columns.

Those are the two biggest stumbling blocks. If those are not it, then edit your question with the source table definition, the lookup table definition and an appropriate insert statement for both so we can help identify the specifics of what is awry.

user_1819650
Related