Re: Duplicate copy rows?? Help!!

#1

I remember having the same problem while moving data from Sybase into
Sqlserver.It duplicated the rows for some tables with no errors generated. It
was only at a later step that I started noticing the duplicates- at that
point I had a pressing deadline and just kept double checking each time I ran
the package. And it was a totally random occurence.
--
Cheers!

"Josep" wrote:

Quote:

Do you have primary keys in this table ?
If you can set one, then you shouldn't have repeated rows and you could find
when they duplicate...

Josep.

"Jonathan Hwang" <JonathanHwang (AT) discussions (DOT) microsoft.com> escribió en el
mensaje news:CCC02282-FF89-44C4-9B28-2E2CF5D6A999 (AT) microsoft (DOT) com...
I have designed and scheduled running of a very simple sql 2000 DTS
package.
Out of my years of experience, I have not encounter this problem before.
However if you know, you must be an expert!

Well... I am trying to schedule a job to run during off peak hours to
copy
13 million records from a production table to my standby server. Same
table
to same table..no special tricks... column to column...

I have set a transaction read committed property and 5000 as my batch size
as my package property. For nights now...and it completed, however, it
duplicated all my rows... so I have 26 million on my destination table!
in
production, there were only 13 million... The job actually completed
successfully and the history only has one entry for the run!

Any setting in SQL job or within package that I'm not aware of? Help!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Duplicate copy rows?? Help!!

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Duplicate copy rows?? Help!! - 12-15-2005 , 05:31 PM