rs80 (4/16/2013)
I have two oledbsources. One oledbsource has the distinct list of product ids (DataSet A) and another oledbsource has all of the order information with product id (DataSet B). How do I get all those orders (DataSet B) that have product ids in DataSet A?For example:
Dataset A
order id product id
1 1
2 1
3 1
Dataset B
product id
1
2
the result set should be
order id product id (DataSet B)
1 1
2 1
3 1
The Merge join transformation didn't give the desired results.
join the two tables on productId?
ps...are you sure your explanation of which data set is which is correct?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day