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 layout 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.