SSIS Script get data from table and loop through

CipherIS used Ask the Experts™
How do you write a script in SSIS to get data from a table and loop through the data.  I need to do this to determine if a task needs to be performed.  A stored procedure would work also (calling the stored procedure).
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Reza RadConsultant, Trainer

do you mean that you want execute a stored procedure for every row in table's data?
if yes, you can use data flow task, with oledb source , set it to table
and then use OLEDB command and execute your stored procedure there, you can use output columns of source as input parameters of oledb command.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial