>Hi.
>Is it possible to call a user define function from a DTS ActiveX Script.
>There is my code :
>Function Main()
> If trim(DTSSource("TXT"))="MONTHLY STATEMENT" THEN
> DTSDestination("LPAGE") = "1"
> Else
> DTSDestination("LPAGE") = "0"
> End If
> DTSDestination("DDATE") = date()
> DTSDestination("NDATE") = dbo.fn_tton(date())
> Main = DTSTransformStat_OK
>End Function
>
>It doesn't recognize the function.

AFAIK, you cannot call SQL function from DTS script. However, you can create and call VBscript function or open ADO connection.