I try to execute DTS package from VB 6 which imports
csv file to one of the tables. I like to fail the entire package
if any of row in text file are rejected, if all rows are OK I like
to commit the transaction. I managed to accomplish this by
setting following properties on DataPumpTask2:
MaximumErrorCount = 0
DataPumpOption = 0
The only problem I have is when all row of data are OK, the last
row is not imported. If I change:
DataPumpOption = 1
then all rows from text file previous to the one which is rejected
are imported to the table. What do I have to do to force the last
row to be imported in case where all rows in text file are OK?

Any help is greatly appreciated.

John Rychter