Post reply

Combine the Foreach Loop and the Execute SQL Task?

  • April 2, 2012 at 8:19 am

    #258441

    Three flat files

    test1.txt

    test2.txt

    test3.txt

    located in folder c:\Folder

    Column names in these folder ContactId, FirstName, MiddleName, LastName.

    i want to insert data from these files in to table called "ContactParameter" which is having same columns. What

    What should be the approach if you want to Combine the Foreach Loop and the Execute SQL Task?

  • April 2, 2012 at 12:32 pm

    #1467807

    Why the Execute SQL Task? That will not help you efficiently load files from SSIS. Did you mean Data Flow Task?

    Looping Through and Loading Files with SSIS

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • April 2, 2012 at 2:32 pm

    #1467901

    Hi

    Use the datflow task inside the foreach loop container

    Configure the foreachloop enumerator to your folder

    Thanks,

    Mark

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

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