Is there any way to MOVE data using DTS instead of just copying it? SQL Server 2000 #sqlhelp

@SQLwitch Its been a while since looking at DTS but as far as i'm aware the answer is no, unless you write some sort of custom code...

@SQLwitch Yes. Create connections for both locations and use a data pump task between them. #sqlhelp