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 is resource db in sql server?

0 Answers  

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

How many types of cursor type are there?

0 Answers  

What is the latest version of microsoft sql server?

0 Answers  

I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,

What is sub-query in sql server?

0 Answers  

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

Explain about Joins?

0 Answers   Infosys,

What are the main control-of-flow T-SQL constructs?

1 Answers  

Delete duplicate rows without using rowid.

0 Answers   Nagarro,

What are three SQL keywords used to change or set someone?s permissions?

3 Answers  

For more SQL Server Interview Questions Click Here
Categories