Hi,

I found sproc to be much faster than using DTS lookups during Data transfer.
Is it good idea to use multiple update statements or cusor in the sproc.
which will give better performance ?. Any limitations on recordset size in
using cursors ?.

The data to be transferred is abt 1.5 million records.

Thanks,