complex join between two datasets

[pms18066]

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?

 

[drtree]

Hi,

I think that you could use a Derived Column transformation (

http://www.bimonkey.com/2009/08/the-derived-column-transformation/)

in DataSet_2 set prior to doing the join with DataSet_1. You could also do the value extract in SQL prior to doing to the join (with Dataset_1) but I think that the Derived Column transformation may be quicker.

HTH,

Doc Tree