i have 5 logging tables with keys to join like

Table 1:

Columns : A,B,C

Table 2:

Columns : D,E,F,G

Table 3:

Columns : H,I,J,k,l

Table 1:

Columns : M,N

Table 1:

Columns : A1,B1,C1

i want to pick only few columns from the above tables which have no relationships and no same columns to do union all, so here i am thinking to have different ole db sources and then they can be loaded into one flat file?