Post reply

how to load a folder in to data base in single package

  • October 14, 2010 at 6:11 pm

    #230519

    hello,

    I have 10 files of same type in a folder, I want to load it into data base. how can I do this

    I have 10 files in which 5 are .csv and 3 .txt and 2 are word, how can we load this through single package......

    please can any one tell me one real time problem in ssis and its solution, it would be really helpful in my interview......

    thanks in advance

    Sasi.

  • October 14, 2010 at 7:29 pm

    #1237271

    Check out the ForEach Loop Container.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • October 14, 2010 at 7:38 pm

    #1237272

    hello,

    thanks for giving reply, but in For each loop container, which connection should we need to make

    and is we can load all types .csv , .txt and word files using single for each loop?

    thanks

    Sasi.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply