Re: Manual replication through DTS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

There is a foxpro 7 app that runs as a scheduled task on the database
server, builds a DTS package in COM interop, and then executes it. I've
built a debug version of the app that saves the DTS package to file for
examination, and the properties of the failing task are all consistent
between executions that succeed and executions that fail.

The row that throws the error varies between runs of the job. The app
running the website which the destination database drives is halted
under the control of this process, the source database COULD be touched
by users during execution. The source database tables all have the same
PK constraints, and use the same stored procedure based PK generation
to allocate IDs. The source database is not locked, but the errors are
thrown well before the end of whichever table the process halts on.

The runtime until error has been varying as well.

The question I'd have is if anyone else has investigated similar
problems far enough to determine what kind of network issues can make a
DTS DataPump package 'hiccup' and double-insert a row? I saw the below
article about someone experiencing an apparently similar problem, but
no resolution on a cause, just a manual fix.

Differences that I can see in the scenario I'm facing: SQL 2000 sp 3
both ends, 2003 server on source, 2000 server destination, not
clustered on either end.

Should I recommend that the network admin side of our shop get with PSS
to troubleshoot this, or does anyone have a suggestion (other than
switching to a scheme where SQL Server Replication can do the job,
rather than relying on a client code app to fake it - our upper
management has dictated No Replication for the foreseeable future for a
variety of reasons)

.

Relevant Pages

  • Re: Prolog on a web server
    ... thrilled if you wanted to load it all into server VM:-/ ... rapidly build yourself a desktop app (Delphi? ... As for Prolog, it could surely be the basis of a decent ... grown-up database query language (an open standard dialect ...
    (comp.lang.prolog)
  • Re: Python Database Apps
    ... It's gonna be a desktop app. ... so that I don't need a database server on the client side. ... If you have an offline mode then the most important thing to work out ...
    (comp.lang.python)
  • Re: HELP PLEASE - need app to modify multiple MDB table designs simultaneously
    ... ONE database runs ONE application and EACH ... application runs only ONE web site and it work great this way. ... particular app, it would not be efficient to have ONE application run ALL ... web sites on my server. ...
    (microsoft.public.vb.com)
  • Re: HELP PLEASE - need app to modify multiple MDB table designs simultaneously
    ... ONE database runs ONE application and EACH ... application runs only ONE web site and it work great this way. ... particular app, it would not be efficient to have ONE application run ALL ... web sites on my server. ...
    (microsoft.public.inetserver.asp.db)
  • Re: HELP PLEASE - need app to modify multiple MDB table designs simultaneously
    ... ONE database runs ONE application and EACH ... application runs only ONE web site and it work great this way. ... particular app, it would not be efficient to have ONE application run ALL ... web sites on my server. ...
    (microsoft.public.inetserver.asp.general)