SQLServerCentral / SQL Server 2005 / Business Intelligence / Approch For picking each value from the table and assign to package variable and use. / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 13:22:45 GMT20RE: Approch For picking each value from the table and assign to package variable and use.http://www.sqlservercentral.com/Forums/Topic1418454-147-1.aspxYou're welcome. Thanks for the feedback.Tue, 12 Feb 2013 07:58:56 GMTopc.threeRE: Approch For picking each value from the table and assign to package variable and use.http://www.sqlservercentral.com/Forums/Topic1418454-147-1.aspxThanq very much for you approch, It work for me :-)Mon, 11 Feb 2013 23:25:57 GMTTony1234RE: Approch For picking each value from the table and assign to package variable and use.http://www.sqlservercentral.com/Forums/Topic1418454-147-1.aspxYou 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 [i]Foreach ADO Enumerator[/i]. 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.Mon, 11 Feb 2013 16:58:50 GMTopc.threeApproch For picking each value from the table and assign to package variable and use.http://www.sqlservercentral.com/Forums/Topic1418454-147-1.aspxHi all,I have a requirement like, In my table have a data as shown belowTable:-ID Tablename ---------------------------1 Table12 Table23 Table3...N TablenI need a package to pick each tablename column value and assign that to variable and used it in next tasks in package. ThanksMon, 11 Feb 2013 08:01:56 GMTTony1234