Im new to SSIS and cant figure out the best way to do a merge/join when there is no column that I can do a straight map on between them.
I need to join TWO DATASETs in ssis where column_A in the first dataset is in column_B in the second dataset. and Column_B is delimited with a |(pipe).
the data will resemble
Dataset_1.column_A == 123
Dataset_2.column_B == 010|123-01|123
Any suggestions?
I need to join TWO DATASETs in ssis where column_A in the first dataset is in column_B in the second dataset. and Column_B is delimited with a |(pipe).
the data will resemble
Dataset_1.column_A == 123
Dataset_2.column_B == 010|123-01|123
Any suggestions?