Does anyone have a nice script that can "Propercase" the values of a column in the dataflow. I was thinking of a Transform Script Task, with a Input and Output Column, which can be transformed.
With Propercase i think:
STEVEN SPIELBERG becomming Steven Spielberg
Maybe also with some exceptions soo that "DELIVERY EU" stays "Delivery EU"
you can use the following within a script to convert to proper case.
Row.Name = StrConv(Row.Name, vbProperCase)
You could setup some select case statements for exceptions...
Frank
sql
No comments:
Post a Comment