Hello, here's a strange one...
I'm using SQL 2K and I set up a dts which imports data
from a csv and inserts it into a table. The indexes/keys
of the table is set with a UNIQUE key and with the
IGNORE DUPLICATE KEY option ticked, because
I don't want to insert duplicate rows.
The dts works fine, but fails (ie Workflow is not a success)
due to the error message that is caused by sql2k.
The dts is designed so that after success, it will continue
with some other tasks, but because of the error message
(and even though it's run it successfully), it fails by default
and doesn't carry on with the other tasks.
Is there any way to turn off the message, or tell the dts
to ignore it or bypass it?
Would very much appreciate any tips/hints.
Thanks.
Raul.

Hi Raul
only other way to see the events raised by DTS is to
implement the dts logic in VB by referencing the DTS
library where you have events to denote the status of the
tasks run and final outcome. You can presumably do the
necessary custom task after the task completes there by
overcoming hte failure message given by sql2k.

Sunic