Post reply

variable looping

  • February 18, 2013 at 8:18 pm

    #274284

    Hi all,

    i have one ssis package which has to read file name from table and assign it to one object type variable.

    but how to use for each loop container to loop through each file name in the object variable and read corresponding file to insert records into table.

    thanks

  • February 18, 2013 at 9:14 pm

    #1589021

    Following link give you example of using foreach loop for ado

    http://www.codeproject.com/Articles/14341/Using-the-Foreach-ADO-Enumerator-in-SSIS

    Create an execute sql task that returns full resultset

    You should first create a variable to hold the output of the loop.

    In the data flow task you shoul create a flat file source,

    you can use expression for source connection using the variable

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • February 19, 2013 at 1:46 am

    #1589067

    thanks joe

  • February 19, 2013 at 2:01 am

    #1589071

    You are welcome.

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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