CipherIS
asked on
SSIS Script get data from table and loop through
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).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.