Hello,
Is it possible to exlude some rows during insert in DTS? or is it possible
to exlude last row from insert batch
Thx

You can do this in the transform script of your data pump.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"kailux4" <kailux4 (AT) discussions (DOT) microsoft.com> wrote

Hello,
Is it possible to exlude some rows during insert in DTS? or is it possible
to exlude last row from insert batch
Thx

Hi Tom,
as i am new to DTS Programming,it will be great if you tell me how?
Thanks

"Tom Moreau" wrote:

Here's a snippet from the BOL:

Function Main()
If DTSGlobalVariables("LoadComplete").Value = True Then
Main = DTSTransformStat_SkipRow
Else
Main = DTSTransformStat_OK
End if
End Function
Basically, if your return code is DTSTransformStat_OK
, then it will insert the row. If it is DTSTransformStat_SkipRow, it will
skip the insert.
--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"kailux4" <kailux4 (AT) discussions (DOT) microsoft.com> wrote

Hi Tom,
as i am new to DTS Programming,it will be great if you tell me how?
Thanks

"Tom Moreau" wrote: