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?
order id product id
the result set should be
order id product id (DataSet B)
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