...and what is in the DTS package? If there is no command in the DTS package

to delete the existing data, or to update the existing data with the

corresponding data in the source, then DTS is probably going to assume that

you want to *append* the incoming data to the *existing* data...



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Marcus Pina - JUVX" <marpia@J...>

Subject: [asp_databases] Re: Dupplicate SQL entries from Access DB





Sorry,



I've setup a local DTS package which connects to the access db

through the Access ODBC Driver and have it scheduled to run every

night around 8:00 P.M.



Is the above information suffucuent? sorry but am kind of new to

Data transfer.



Marcus



-----Original Message-----

From: Ken Schaefer [mailto:ken@a...]

Sent: Sunday, August 12, 2001 8:18 PM

To: ASP Databases

Subject: [asp_databases] Re: Dupplicate SQL entries from Access DB





First you could tell us *how* you are doing it at the moment, then we can

tell you *what* you are doing incorrectly.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Marcus Pina - JUVX" <marpia@J...>

Subject: [asp_databases] Dupplicate SQL entries from Access DB





: I am pulling data from a access db into a SQL 2000 db, the problem is the

: data is not being

: overwritten but duplicated... can someone tell me what needs to be changed

: in either the SQL

: datbase or ??