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
- 5117 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
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is data file in computer?
Does a specific recovery model need to be used for a replicated database? : sql server replication
Where can you find the error log information? : sql server database administration
Which is the latest version of sql server and when it is released?
What Is Rdbms?
can we have a nested transaction? : Sql server database administration
What is the function of sql server agent windows service?
What is database replication? What are the different types of replication you can set up in sql server?
Explain linked server in sql?
Explain the ways to controlling cursor behavior?
How does stuff differ from the replace function?
Explain partitioned view?
Define msdb database?
How you can move data or databases between servers and databases in sql server?
