Thank you for replying.

Please see the attachment that shows the transformation. I need help with the following as I am not familiar with .NET script.

1)How do I rewrite the code (from the attachment) in ActiveX Script Component

2)Should I use a destination or source Transformation

3)How will it connect with the data flow