I can not find anything on this. I have an Execute SQL Task that calls a Stored Proc with defined variables(ADO connection) that will be input as the Parameter values.
I have a CSV file that contains the data for the sp parameters as field in each row.
I need to loop through this file and execute the SP for the parameters in each row.
How do I do this the best way. I can not figure out how to do this with a for each loop but suspect this is part of the answer.
Thanks In Advance