>SCATTERING a row to an object works great if you only need to pass a single row, but what if you need to pass multiple rows at a time? Would the best way be to scan through the data, scatter to an object, call the update method and then move to the next row and repete the process?
>

You may create an array of objects, and redimension it as needed, then traverse the array and do the updates.