Using a DTS ActiveX script, I am DTS'ing a flat file to a table.
In this DTS process, how do I bypass the loading of selected rows?
EXAMPLE: If the LW_GROUP_ID is NOT NUMERIC, I want to BYPASS the LOADING of this Record into the SQL Server table
'Visual Basic Transformation Script
'Copy each source column to the destination column Function Main()
DTSDestination("log_date") = DTSSource("Col001")
If IsNumeric(DTSSource("Col002")) Then
DTSDestination("lw_group_id") = DTSSource("Col002")
Else
DTSDestination("lw_group_id") = 0
End If
Main = DTSTransformStat_OK
End Function
In this DTS process, how do I bypass the loading of selected rows?
EXAMPLE: If the LW_GROUP_ID is NOT NUMERIC, I want to BYPASS the LOADING of this Record into the SQL Server table
'Visual Basic Transformation Script
'Copy each source column to the destination column Function Main()
DTSDestination("log_date") = DTSSource("Col001")
If IsNumeric(DTSSource("Col002")) Then
DTSDestination("lw_group_id") = DTSSource("Col002")
Else
DTSDestination("lw_group_id") = 0
End If
Main = DTSTransformStat_OK
End Function