Re: bugs with IF, SKIPROW, or ISNULL?
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 04/14/04
- Next message: Darren Green: "Re: DTS and Cluster"
- Previous message: Tunji: "DTS and Cluster"
- In reply to: Gregor Anton: "Re: bugs with IF, SKIPROW, or ISNULL?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 14 Apr 2004 20:19:43 +0100
In message <uvOrfNbIEHA.3720@tk2msftngp13.phx.gbl>, Gregor Anton
<nospamplease@hotmail.com> writes
>interesting, I'll try that, I figured the if statement would take care of
>it, if condition met then skiprow else okay..
Functions return a result, that is their main point. The result is what
the DTS engine uses to decide what it does next.
The skip row is a constant. You are assigning to the function output,
but unless you exit the function then you then assign a new value to the
function result and that is acted upon.
-- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org
- Next message: Darren Green: "Re: DTS and Cluster"
- Previous message: Tunji: "DTS and Cluster"
- In reply to: Gregor Anton: "Re: bugs with IF, SKIPROW, or ISNULL?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
