How do you connect 100 files as a flat file sources in one
package of SSIS?
- 2 Answers
- 4508 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
What is the report model project?
Your table has a large character field there are queries that use this field in their search clause what should you do?
How to select some specific rows from a table in ms sql server?
What is the default Port No on which SQL Server listens?
What do you understand by a view?
What is stored in the mssqlsystemresource database? : sql server database administration
What is the use of custom fields in report?
How to connect a database with sql express.?
What is the usage of the sign function?
What are the drawbacks of reporting in ssrs?
What is self join in sql server joins?
What is the purpose of the model database?
What is SQL Azure?
What is the difference between resultset and resultsetmetadata?
What is report snapshot in ssrs?
