rshiney
3/30/2007 3:04:00 PM
I have a database function that I would like to access within my DTS
package. The database function is called parsestate which takes a
varchar data type as input and returns the two character state
abbreviation.
How can I use this in an activex to transpose columns during a
transformation?
This doesn't work.
Function Main()
DTSDestination("STATE") = Parsestate(DTSSource("TEXTSTATE"))
Main = DTSTransformStat_OK
End Function