Hi.
I have a DTS package that uses an ActiveX script for transferring data from
a text file to a SQL 2000 table. I'm testing a DTSSource column for spaces
and exiting the routine if it's spaces.
I set MAIN = DTSTransformStat_ExceptionRow and Exit the function.

It worksd fine, I get the error row in the log but I don't get a meaningful
error message.
I tried to set MAIN = DTSTransformStat_ExceptionRow("My Error Message") but
I got an error in the log saying "Wrong number of arguments".

How do I pass along a meaningful error message when I set MAIN =
DTSTransformStat_ExceptionRow?

Here's my code:

Function Main()
If (Trim(DTSSource(6)) = "" Or Trim(DTSSource(7)) = "") Then
Main = DTSTransformStat_ExceptionRow
Exit Function
End If

DTSDestination("RecordType") = DTSSource(1)
Etc...

TIA.

Rita