Post reply

Approch For picking each value from the table and assign to package variable and use.

  • February 11, 2013 at 8:01 am

    #289084

    Hi all,

    I have a requirement like, In my table have a data as shown below

    Table:-

    ID Tablename

    ---------------------------

    1 Table1

    2 Table2

    3 Table3

    .

    .

    .

    N Tablen

    I need a package to pick each tablename column value and assign that to variable and used it in next tasks in package.

    Thanks

  • February 11, 2013 at 4:58 pm

    #1586784

    You can select values from your table into a Variable of Type Object using an Execute SQL Task. Then you can iterate over that Variable using the ForEach Loop Container (FELC) setup with an Enumerator of type Foreach ADO Enumerator. The FELC can assign each column in the resultset to a different variable so you can work with variables that contain the name and id in Tasks contained within the FELC.

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

  • February 11, 2013 at 11:25 pm

    #1586845

    Thanq very much for you approch, It work for me 🙂

  • February 12, 2013 at 7:58 am

    #1587031

    You're welcome. Thanks for the feedback.

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

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

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