Iterating 150k records with 5 columns in it via an object type in a foreach loop container in SSIS with a Stored Procedure is taking too much time
I have a use case where in i need to go though all the rows in a table and apply some transformations (also updates) for each row.