I have a column in my DB that has words separated by commas. I am trying to transform this field and I want to REPLACE the " , " with a PIPE " | ".
I have created and ActiveX scrip to do this but it seems to error out. Any suggestions?
DTSDestination("APPLICATIONS_TX") = Replace(DTSSource("APPLICATIONS_TX"), ", ", " | ")
Main = DTSTransformStat_OK