I'm having a few problems with a basic DTS package.

I need to update two tables with a flat text file to overwrite the existing
data. At the moment I have an ugly version working but it means
deleting the existing file before updating the new data.

If I encounter a PK constraint I then have no data in either table.
Until I manually change the txt file name and import the old txt file.

I know there must be an easier way???

I tried the package properties, advanced, use transactions but this isn't helping as the sql statements that delete table are working it is in the OLE DB connection nodes that the package fails.

But if I try to insert a on failure connection from there to another txt source then i get a defining preferences is not valid error.