How do you connect 100 files as a flat file sources in one
package of SSIS?
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
Explain cdc and sql injection?
What are the new features are introduced in sql server 2012 reporting services?
What do you understand by intent locks?
Describe the left outer join & right outer join. : sql server database administration
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
How we create SQL Server 2005 Reporting Services ? Give me Sample
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is temporary stored procedure?
What are the disadvantages of primary key and foreign key in SQL?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are the difference between “where” and “having” clause in sql server?
What do you understand by user-defined function in the sql server?
What is multi-statement table-value user-defined function?