Problem with DTS and Null Records

#1

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

#2

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

"robboll" wrote:

Quote:

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

#3

I knew it had to be simple. Thanks.
Charles Kangai wrote:

Quote:

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

"robboll" wrote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Problem with DTS and Null Records

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Problem with DTS and Null Records - 08-21-2006 , 04:08 PM

RE: Problem with DTS and Null Records - 08-21-2006 , 09:28 PM

Re: Problem with DTS and Null Records - 08-22-2006 , 07:06 AM