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

  • 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

  • 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

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

  • 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