Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

complex join between two datasets

Status
Not open for further replies.

pms18066

Programmer
Jan 12, 2005
94
US
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?
 
Hi,

I think that you could use a 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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top