Home Forums SQL Server 2005 SQL Server 2005 Integration Services Is it possible to load multiple flat files into table without using foreach loop container? RE: Is it possible to load multiple flat files into table without using foreach loop container?

  • April 21, 2015 at 11:13 am

    #1792506

    Phil Parkin (4/21/2015)

    p.shabbir (4/21/2015)

    Hi phil,

    Thanks for the quick response. I know that one DFT per file will do but, what if we have more files(Say 50 or 100 files). It will be pain to create that many DFT's.

    Can you briefly tell me how to do with forloop container or provide me a reference link.

    Thanks,

    I can think of a way to do it with a for loop, but the way that comes to mind is just an abstruse way of implementing a foreach loop (FEL).

    You will find few examples to refer to, because everyone else will be using a FEL 🙂

    Is this some sort of fun technical challenge, or is there good reason not to use a FEL?

    Actually I have been asked in an inteview. So just wanted to check and try out once by ssc experts suggestions and sorry for that not mentioning initially.