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
- 5287 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
How to truncate the log in sql server 2012? : sql server database administration
What is an expensive query?
What is page-level compression?
What is a natural primary key?
What are the properties of primary key?
What are system databases into sql server (2005/2008) : sql server database administration
Explain different types of locks in sql server.
What is the difference between for auto and for nested?
What is intellisense?
How to integrate the ssrs reports in application?
What is an indice?
Can you get second highest salary from the table?
How do you create a data source?
Explain few examples of RDBMS?
Explain various data region available in ssrs with their use?
