Re: bugs with IF, SKIPROW, or ISNULL?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Gregor Anton (nospamplease_at_hotmail.com)
Date: 04/13/04 

Date: Tue, 13 Apr 2004 17:59:36 -0600

interesting, I'll try that, I figured the if statement would take care of
it, if condition met then skiprow else okay..
"Darren Green" <darren.green@reply-to-newsgroup-sqldts.com> wrote in message
news:mQDibiFvbveAFwfw@sqldts.com...
> In message <O$fZSLZHEHA.3564@TK2MSFTNGP09.phx.gbl>, Gregor Anton
> <nospamplease@hotmail.com> writes
> >are there any bugs with if statements or skiprow?
> >
> >when executing the transformation script below it doesnt skip any
records...
> >I have to filter the records in the source query for some reason...
> >
> >IF ISnull(DTSSource("MAIL ADDRESS")) and ISNull(DTSSource("MAIL CITY"))
and
> >ISnull(DTSSource("MAIL ST")) AND ISnull(DTSSource("MAIL ZIP")) then
> > Main = DTSTransformStat_SkipRow
> >else
> >
>
> You should add an Exit Function statement after the Main =
> DTSTransformStat_SkipRow, otherwise it will keep going and end up with
> the Main = DTSTransformStat_OK as the final result.
>
> Filtering in a source query will probably perform better.
>
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
>
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>