i have table tab1 with columns a,b,c and table tab2 with columns x,y,z now i have to load the data into tab3 with columns a,b,x,y
so i have created two oledb sources (tab1 & tab2) and a oledb desitination(tab3) now which transformation should i use to get two columns(a,b) form tab1 and two columns(x,y) from tab2 and load into destination table tab3(a,b,x,y)
please let me know how to achieve this
There must be a column in common (i.e. one that can be used in a join operation. This column must be of the same data type and size on both tables.
> the two data sources (select commands) must be ordered by this common column (this will require the use of setting "SQL command").
> In the data sources, advanced edit, input and output tab (last tab), set the output IsSorted = True; and the sorted column set Sort Position = 1
> use a Merge Join component in the data flow, joining the left and right data flows to it - if the above sorting was done correctly, the data sets will automatically be joined.
> select the output you require from the merge join by ticking the required boxes
> from the merge join, connect to the destination table.
> in the destination, map the columns to the destination table columns
Space, the final frontier? not any more...
All limits henceforth are self-imposed.“libera tute vulgaris ex”