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
- 5085 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 difference between lock, block and deadlock? : sql server database administration
Explain “row_number()” in sql server with an example?
When I delete any data from a table, does the sql server reduce the size of that table?
What are the different normalization forms?
What are the two authentication modes in sql server?
State the difference between union and union all?
What is normalization of database? What are its benefits?
What is the meaning of resultset type_scroll_insensitive?
How can I get data from a database on another server?
What is a join in sql? What are the types of joins?
What is the main difference between ‘between’ and ‘in’ condition operators?
Define full outer join in sql server joins?
How many databases Microsoft SQL server provides?
Do you know what is lock escalation?
What the different components of Replication and what is their use?
