CODEWITHSUNDEEP
visual-studiossis
Joel
Joel

Reputation: 438

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

Upvotes: 0

Views: 546

Answers (2)

John Saunders
John Saunders

Reputation: 161773

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.

Upvotes: 0

Registered User
Registered User

Reputation: 8395

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.

Upvotes: 2

Related Questions