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

what type of indexes physically sort data?

3 Answers  

What are cursors in ms sql server?

0 Answers  

How to get the number of affected rows?

0 Answers  

What happens if null values are involved in arithmetic operations?

0 Answers  

what is trigger . hw will it use them

2 Answers   TCS,

What is exporting utility?

0 Answers  

How to sort query output in descending order in ms sql server?

0 Answers  

What is the osql utility?

0 Answers  

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

Define master database?

0 Answers  

How to genrate automaticlly empid like gt001

4 Answers  

Do you know how to store and query spatial data?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories