Hello:

I have a DTS package that moves some tables from a
production database to a reporting database. The tables
all have primary keys.

I do not want duplicate records in my destination tables
but when my DTS package runs, it just stops when it
reaches a value that already exists in my destination
tables. I would like the package to skip the duplicates
and complete.

Any ideas would be appreciated

Brennan

Moves some tables ? Or move new records ? Don't know you're record count ..
if it's small you could just drop the reporting table create it againg and
then
put in the total production table.

Or you could make an sql-statement which only inserts new records.

\Michael V.

Brennan <anonymous (AT) discussions (DOT) microsoft.com> wrote

The most scalable solution for moving production data to a reporting database in SQL server is to make use of replication
The two kinds of replication that would benefit you here would be either snap shot or transactional replication. The decision needs to be made on your end as to how current the data needs to be for reporting.

If you decide to stick with running a dts try porting the data into a staging table and then inserted only the items which do not already exist in your reporting table [using an Insert Join]. Any questions regarding the two replication methods mentioned above can be directed to the email address attached to this post