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
- 5196 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 co-related sub query?
Tell about MOM Tool(Microsoft Operator Manager)?
query processing
What are the three different part of rdl file explain them?
What sql server means?
How to execute stored procedure and set temp table in sql server?
How many types of the database links?
What is awe?
How to disable stored procedure sql server?
List the data types available in mssql?
What is the difference between insensitive and scroll cursor?
What are the various editions of sql server 2017 that are available in the market?
Please illustrate physical database architecture? : SQL Server Architecture
How does clustered and non clustered index work?
What is simple indexing method?
