SSIS: How to check if string value from one column of a table matches with string value (from the right) in a column of another table? -

i pretty new ssis , below sql query explains trying do:

select * table1 t1 join  (select id, len(id) len table2) t2 on right(rtrim(t1.col) , t2.len) = t2.id 

there might better query in sql same intrested how implement logic in ssis?

i need find records table 1 col (from right) matches id value retrieved table 2.

i use ssis lookup task using partial cache option: https://msdn.microsoft.com/en-us/library/ms137820.aspx

this execute specified sql statement row-by-row. sql statement design have coded in question - getting sql complex join requirement.

for performance reasons, have edit generated sql (see step 12 on page) remove outer derived table select.