loop thru columns and find isExecute =1 and loop the name column in dataflow tasks

Question

I have table with record isExecute = 1 and 0 value.

I need to get the columns isExecute =1 and loop the name column into my set of data flow tasks

---

ShanmugaRaj

Answer 1

Not sure what your requirements are, but you could execute a query with the following WHERE clause in an Execute SQL Task:

... WHERE isExecute = 1;

Store the results in an object variable and loop over them using a For Each Loop container.

---

MCSA SQL Server 2012 - Please mark posts as answered where appropriate.

Answer 2

By using the execute sql statement, i will get say 3 records.

I want to now use those records in my for each loop by getting column1, column2 values from the query result

---

ShanmugaRaj

Answer 3

This article explains it all:

Loop through ADO recordset in SSIS

---

MCSA SQL Server 2012 - Please mark posts as answered where appropriate.