Yes I tried setting the error condition and the truncate condition on the DataSource object but that did not seem to work.

What I simply want to...

uugghh, MS what did you do to a simple but easy to use DTS. I too was in "truncate hell". I read all sorts of...