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

CTE(common table expression)

1 Answers   Thomson Reuters,

What gets stored inside msdb database?

0 Answers   Abacus,

What is nested transaction?

0 Answers  

What do you understand by triggers and mention the different types of it?

0 Answers  

What is trigger ?

7 Answers   Cap Gemini, SQL,

How to select an exiting database using mssql_select_db()?

0 Answers  

What does null mean?

0 Answers  

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

What is data source object?

0 Answers  

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

What is cursor in ms sql server?

0 Answers  

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

For more SQL Server Interview Questions Click Here
Categories