Post reply

ssis pasing variables and for loop

  • May 31, 2010 at 4:23 am

    #223206

    i want to use for loop, which will go over a table (using a query)

    and will activate "Data Flow Task".

    i want to pass this "Data Flow Task" a values from the "for loop",

    and in the "Data Flow Task" there is a "OLE DB Source" which i want to pass it the variable - how can i do this?

    Thanks

    Peleg

  • May 31, 2010 at 4:31 am

    This was removed by the editor as SPAM

  • May 31, 2010 at 4:35 am

    #1174455

    the table contains AccountManagerId & email's,

    which i want to pass to the "OLE DB Source"

    which in the "Data Flow Task"

  • May 31, 2010 at 4:39 am

    #1174456

    Try using For each loop container that should help you.

    Nag

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537

  • May 31, 2010 at 5:04 am

    This was removed by the editor as SPAM

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

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