sunder.mekala (2/18/2013)
Hello friends,i have requirement where i have take data from different tables of sql server db, but here the important thing is tables doesnt have any relationship among them, not even one, as they are just logging tables of packages, so i thought of using multiple ole db sources, with one ole db source having data from one table and repeat for others.
Here i have 5 tables with different columns in each.
i am not sure how to load that into a single flat file or excel file destination.
Your help is much apprecaited, Thankyou.
--
Sam.
Only a guess as I can't see your structures however if they are just log's can you not do something like this in your data source and then pass the data set to the destination table?
Andy
SELECT
COL1
,COL2
,COL3
,COL4
,COL5
FROM
TABLE1
UNION ALL
SELECT
COL1
,COL2
,COL3
,COL4
,COL5
FROM
TABLE2
UNION ALL
SELECT
COL1
,COL2
,COL3
,COL4
,COL5
FROM
TABLE3
-- Ect --
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe