SUB: what is the Equivalent of DTSTransformStat_SkipRow(2000) in 2005

I want to know how to skip a row in sql 2005.

Please let me know if any body have the answer

In 2005 you get to choose what is added to the output buffer. If you
validate and do not like the row then do not add it. Simple as that



"DDR" <DDR (AT) discussions (DOT) microsoft.com> wrote

In message <#VeWgRBJFHA.4028 (AT) tk2msftngp13 (DOT) phx.gbl>, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> writes
To expand a bit, before you leap down the route of the script transform
if you perceive it to be the closest to the current ActiveX Script
Transform, I suggest you explore the other transforms first.

My first choice to exclude rows inside the pipeline would be a
conditional split transform.

Don't try and transfer ideas or practices from DTS to SSIS, the overall
outcome of the package may be the same but I think the design will
almost always be very different.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org