I have two tables. For example Table 1: letter number a 1 b 2 c 3 Table2 : letter number a I b II c III I need to generate the Output : letter number a 1 a II b 2 b II c 3 c III Can someone please me how I can generate above output in SSIS. I need to generate a flat file having the above layout(output). Thanks,

One Data Flow with two Source connections, one to each table. You will need to take the first table and create a Data Conversion to get the integers to Strings. Then do a UNION ALL Transform to bring the two together, taking the Letter from each Source, and the Derived Number from the first and the Number (roman numbers) from the second. Send that to a Flat File Destination.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Hi, If I were you I write my query as below as pass it to Data Source Item. --drop table #Table1 --drop table #Table2 Create Table #Table1 ( Letter Varchar(1) , Number int ) Insert Into #Table1 Values('a' , 1), ('b' , 2), ('c' , 3) Create Table #Table2 ( Letter Varchar(1) , Number Varchar(3) ) Insert Into #Table2 Values('a' , 'I'), ('b' , 'II'), ('c' , 'III') select Letter , CAST(Number as Varchar(3)) as number from #Table1 UNION Select Letter , CAST(Number as Varchar(3)) from #Table2 order by Letter Regards, Balwant.Failure in Life is failure to try...MCTS (SQL Server 2005)