As I process a text file, I need skip rows that that have missing data.
I added the following row transformation script, but it causes every
row to be skipped.
Main = DTSTransformStat_OK
missingFields = ""
if IsNull(DTSSource("Address1")) or trim(DTSSource("Address1").value)
= "" then
missingFields = missingFields + "Address1"
Main = DTSTransformStat_SkipInsert
I've also tried setting Main = DTSTransformStat_SkipRow.
It looks like what's happening is that if one row get's skipped, all
the rows get rolled back.
But I've turned off transactions and still don't get any data.
Any ideas would be greatly appreciated.