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: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

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

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