How do you connect 100 files as a flat file sources in one package of SSIS?

How do you connect 100 files as a flat file sources in one
package of SSIS?

Question Posted / damu1.p

2 Answers
4098 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do you connect 100 files as a flat file sources in one package of SSIS?..

Answer / ramesh

using for each loop and iterate each file in that folde or object

Is This Answer Correct ?

1 Yes

0 No

How do you connect 100 files as a flat file sources in one package of SSIS?..

Answer / prashant

if you mean merging 100 flat files into one, you may
try "Union All" component if the data is similar.

Here's how:

1. Create Flat File Sources for each file.
2. while creating Flat file connection, don't forget to
mention that the first row is columnname.
3. Edit "Union All" component and select all the Input
field names (from all the columns).
4. Point the output to either to a OLEDB or another Flat
destination, map the fields...

Is This Answer Correct ?

0 Yes

1 No

Post New Answer