Yep but you are not going to do this row * row are you?
The way I would do it is at the time of instantiating the package mark the
rows to be moved, set a flag or something.
When you have moved the rows successfully then remove the flagged rows from
the source.
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"jtippell" <jtippell (AT) discussions (DOT) microsoft.com> wrote
Quote:
I'm using DTS to copy records from one SQL server database to another. The
problem that I face is that for each record successfully copied, I wish to
|
delete it from the source database.
Quote:
Can this be done? If so, how?
Kind regards
J
|
Re: how to delete all records transferred from one database to another -
06-23-2004
, 11:45 AM
Linear Mode
