I currently have a DTS package with a TSQL Statement that will insert data from one table to another. On the destination table I have an "ignore Dupe" index derived on all the columns. When ever there are dupes, TSL returns a msg of, Dupes Found. DTS looks as this as a failure. The package still runs but shows up as it failed. From my experience, any return, triggers the DTS package to fail. Is there any way I can compensate for this message and prevent the DTS package from failing?