This VBS function will convert a string into Proper Case (i.e. This Is Proper Case) during the execution of the DTS package. Wrap the DTSSource function with the PropCase function and the result is a Proper Case transformation
example
Function Main()
DTSDestination("Field1") = PropCase(DTSSource("Col019"))
Main = DTSTransformStat_OK
End Function
2007-10-02 (first published: 2002-06-20)
15,443 reads