Hi All,

We require to move rows from source table to target table i.e the rows in
the source table should get deleted.

Is there a way in DTS so that while copying it also deletes the rows in
source table?

Thanks in advance,
Sachin

In message <F2CFF9E7-2A7C-4CD9-AE61-A1BE6A78468B (AT) microsoft (DOT) com>, Sachin
Surana <SachinSurana (AT) discussions (DOT) microsoft.com> writes
Nothing directly, but this should be quite easy to do using some T-SQL
around the edges. Run a query to detect the rows, and either mark them,
record the keys or select the entire row into a staging table on the
source system.

Do the transfer.

Now delete the rows you transferred, using the first stage method to
identify them.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org