My stored proc has two cursors i.e. cursor1 does a select and cursor 2 is within cursor 1. How can this be implemented in ssis please? Please note that for business requirements the stored proc has to be the way it is and the same thing has to be implemented in ssis. Thank you
Maybe get the data from cursor 1 into an object then loop through the rows populating another object with the result of the second cursor.
It's an odd business requirement that says how a function should be implemented - I would ask whoever gave the requirement how it should be coded as they obviously know what they were expecting. Not many developers would accept a requirement like this - I suspect there's a fast staff turnover.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.