Interested to Buy Any Domain ? << Click Here >> for more details...
How do you connect 100 files as a flat file sources in one
package of SSIS?
- 2 Answers
- 5163 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Why use identity in sql server?
List some advantages and disadvantages of stored procedure?
What is checkpoint process in the sql server?
What language is sql server written in?
What are system databases into sql server (2005/2008) : sql server database administration
What is normalization? Explain different forms of normalization?
Explain stored procedure?
What is the difference between update lock and exclusive lock?
How to connect of datebase with sql express.?
What are the differences between substr and charindex in sql server.
How to find which stored procedure is currently running in sql server?
Mention what are the core components of ssrs?
Which Model uses the SET concept
Does partitioning improve performance?
How to enter unicode character string literals in ms sql server?
