How do you connect 100 files as a flat file sources in one
package of SSIS?
Answers were Sorted based on User's Feedback
Answer / ramesh
using for each loop and iterate each file in that folde or object
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
Define Foreign Key?
3 Answers ADP, College School Exams Tests,
How can we delete a table in sql server?
How to loop through the result set with @@fetch_status?
How we can compare two database data?
How do I create an extended event in sql server?
Why would you use sql agent?
What is a livelock?
How can you check the level of fragmentation on a table?
how we can use a database with php.
what is dbcc? : Sql server database administration
How to connect to a sql server using odbc_connect()?
how to define testing of network layers? : Sql server database administration