DTS: Transformation - ActiveX REPLACE

Last Post 22 May 2008 05:23 AM by GoodFella3993. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
GoodFella3993
New Member
New Member

--
21 May 2008 10:45 AM
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?

Function Main()
DTSDestination("APPLICATIONS_TX") = Replace(DTSSource("APPLICATIONS_TX"), ", ", " | ")
Main = DTSTransformStat_OK
End Function

Thanks,
Marc
GoodFella3993
New Member
New Member

--
22 May 2008 05:23 AM
Very true ... so simple ... never dawned on me.

Thank You.
You are not authorized to post a reply.

Acceptable Use Policy