Hello all,

Is it possible to use a User Defined Function in an ActiveX transformation using VB Script?

I created a UDF in the Master DB that will return the date of the last day of the month based on the date passed to it.

My first attempt at this did not work. I don't remember the exact syntax I used (this was a couple weeks back), but it was
something like:

Function Main()
DTSDestination("MEDate") = master.dbo.EOMonth(DTSSource("Prod Dt"))
Main = DTSTransformStat_OK
End Function

No workie!

Can this be done? If so, how?

Thanks for any help anyone can provide,

Conan Kelly