I am having trouble skipping rows when processing a text file.

I want to skip all the rows there col001 doesn't equal "001".
I've tried using both DTSTransformStat_SkipRow, and
DTSTransformStat_SkipInsert. And both insert null values into my
destination table instead of skipping the insert entirely.

Any suggestions as to what I should be doing differently?

Thanks,
Wes

Function Main()
if not DTSSource("Col001") = "001" then
Main = DTSTransformStat_SkipRow
else
'Column Mappings here
end if

Main = DTSTransformStat_OK

End Function

Sorry about the tipple post. I'm using Google Groups Beta, and the
submit button doesn't give any feed back so I hit it a couple of extra
times.

I thought I should clarify the previous post. The code is in a
Transform Data Task that is moving data from a fixed with file to a
table. I'm using SQL Server 2000 sp3.


Wes wrote: