sql server dts: Problem with DTS and Null Records -- sql server dts

Problem with DTS and Null Records

robboll
8/21/2006 2:08:49 PM

sql server dts:

I am trying to produce a result that includes only records with a
Status of "A".

The DTS Package is as follows:

Function Main()

If Instr(DTSSource("Col001"),"A") > 0 Then
DTSDestination("ACTIVITY-STAT") = DTSSource("Col001")
end if
Main = DTSTransformStat_OK
End Function

This generates a table with 824 rows and 306 of them are "A", The
remaining 518 are nulls. Apparently it's doing the job, but including
the rows it skips. Any suggestions to avoid appending null rows
appreciated!!!

RBollinger

RE: Problem with DTS and Null Records

Charles Kangai
8/21/2006 7:28:09 PM

Function Main()
If Trim(DTSSource("Col001")) = "A" Then
DTSDestination("ACTIVITY-STAT") = DTSSource("Col001")
Main = DTSTransformStat_OK
else
Main = DTSTransformStat_SkipRow
end if
End Function

[quoted text, click to view]

Re: Problem with DTS and Null Records

robboll
8/22/2006 5:06:32 AM

I knew it had to be simple. Thanks.
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.