Venki,

In SSIS you get for each loops which do all kinds of things, and really assist with managing the loads into your environment.

BUT (and this is the big but), none of these are actually row based loops, and ultimately they will perform set based operations.

Agree with the above, post what you are trying to do, While and cursors are swearwords on the RDBMS

~PD