September 14, 2011 at 2:47 pm
Hi I have 3 OLEDB Sources and 1-OLEDB gets 3 columns ,2-OLEDB gets 1 Coulmn,3-OLEDB gets 1 column. Now i need to add all this columns so that i can push it into one table at destination and Morover this columns don'y have any relation to each other . I just need to combine all this columns to one so that it looks like one whole table . Thanks in Advance .:-)
September 15, 2011 at 9:05 am
If there is no relation how do you know what rows to put together? Do you want a Cartesian product where every row from one input is merged with every row from the other?
A Merge Transform or a Merge Join Transform would do want you want, but you need to have the data sorted and you need a key/join column. If you just want row 1 from each source to match up, I'd add an incrementing column to each source, even if it needed to be a derived column transform ror script and then use the Merge Transform or the Merge Join Transform.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply