I'm using Data Driven Query Task in a DTS package to transfer some Visual Foxpro Tables onto the MS Sql Server 2000 database.

If the record in the target database is already existing, I update the fields; else, I append the records.

Due to some reason, some records are skipped.

Is there any way to know why they are not processed. What kind of debugging is available for this environment?

Thanks.