Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How do you connect 100 files as a flat file sources in one
package of SSIS?

Question Posted / damu1.p

Answers were Sorted based on User's Feedback



How do you connect 100 files as a flat file sources in one package of SSIS?..

Answer / ramesh

using for each loop and iterate each file in that folde or object

Is This Answer Correct ?    1 Yes 0 No

How do you connect 100 files as a flat file sources in one package of SSIS?..

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

Post New Answer

More SQL Server Interview Questions

Explain sub-query?

0 Answers  

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

what is memory-optimized nonclustered indexes

0 Answers  

What is Transparent Data Encryption?

0 Answers  

what are the critical issues you have resloved in your company

0 Answers   Wipro,

What different steps will a sql server developer take to secure sql server?

0 Answers  

What is the difference between cartesian product and cross join?

0 Answers  

How do you know if sql server is running on your local system?

0 Answers  

How to create dbo table in sql server?

0 Answers  

ehat is the default port no of sql 2000?

2 Answers   IBM,

How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

For more SQL Server Interview Questions Click Here
Categories