SSIS - Create a CSV file from 2 different OLE DB sources

I'm looking for a way in SSIS (2005) to create a CSV file from 2 or more different layout OLE DB sources. Again, the column la开发者_开发知识库yout is different for all the sources.

EX.

Source 1

A,1234,ABCD,1234

Source 2

A,ABCD,1234

Final CSV Result File

A,1234,ABCD,1234

A,ABCD,1234

There are a couple of options. You could combine the results from your inputs into one column and include commas in your data and then merge the two sources together. It's not a great solution, but it would meet your business needs as stated.

Combine the two inputs with a Union All component leading to your Destination component. In the union, you'll have to choose which input columns should go to which output columns.