I need to copy one table from one SQL server to another SQL server. I tried
and the data keeps growing appending. The source table is 13726 and the 1st
time executed the DTS package the destinaton was 13726. The scond time the
source was 13726 and the destination doubled.

Did you empty the destination table before the second
execution?

It will do.

You are either going to have to

1. flag the source rows as having been moved already
2. Clear out the destination each time (costly if your table is large)
3. Use a linked server so your Source Query can be intelligent enough to
know what rows it needs.

The fact that your destination has doubled suggests to me that their is no
Primary Key or Unique Constraint which in itself is something you should
remedy.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Lontae Jones" <LontaeJones (AT) discussions (DOT) microsoft.com> wrote