I have a DTS package with about 20 steps.
It's all simple tasks. Nothing elaborate.
I'm working with 2 remote shared SQL servers. SQLA and SQLB
The DTS package is saved on: SQLB
The package empties 4 tables on SQLA (DELETE FROM tasks)
Then populates those tables with a bit of data grooming.
Last step is to transfer the new data to SQLB.
I set the parallel processing limit to 1.

If I execute the DTS manually - it works perfect.
If I allow the schedule to run the DTS - data is duped in all the tables.
Every morning I wake to duped data.

I can only guess that the first set of data is not being deleted.
How can I troubleshoot this?
I don't have any control over scheduling.
Are there any settings there that can effect this?

thanks!

How are you deleting the data-- truncate table? Have you tried leaving the
old data and only copying over new rows (using SQL instead of a bulk table
copy) that makes sure the rows are unique?

Randall Arnold
"shank" <shank (AT) tampabay (DOT) rr.com> wrote

I'm using DELETE FROM. Maybe that's the issue.
The data is constantly changing throughout all 4 tables. I just figured it
be easiest to dump the old and grab the new instead of comparing record by
record.
thanks!

"Randall Arnold" <randall.nospam.arnold (AT) nokia (DOT) com.> wrote

Try Truncate first. If that doesn't work you may have table structure
problems.

Randall Arnold

"shank" <shank (AT) tampabay (DOT) rr.com> wrote

I've been messing with this for a couple days now. I switched TRUNCATE
TABLE. Much faster, but same difference. I asked the SQL admin to take a log
when the package runs. Because scheduling is out of my control, everything I
try is taking days to test. Is there a list of things I can do to help
troubleshoot?

I have a date field setup with GetDate(). Whatever is happening is happening
at the same time. I also have an ID field with auto-increment. One strange
thing is that the duped records are not populating back-to-back. There's a
break in the ID field.
thanks!

"Randall Arnold" <randall.nospam.arnold (AT) nospamnokia (DOT) com.> wrote