hi,
I had one DTS package job to be scheduled on sql
server agent midnight everyday. Yesterday i found the
data was loaded twice to the destination table, however,
in the job history, there's only one successful job
recorded. Same thing happened today.

The source data was fine, because later on when i delete
the data and reexecute the data load job, the data was
loaded with correct numbers. So it seems the data loading
job was executed twice at midnight, but how come the job
history only shows one successful record, and how can i
solve it? ( the execution time is still as normal these two days)

can anyone help me out?
thanks
Yanping







*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!