I need to get value from one table and if it is (for example) string - TodayDate, I need to change it to "Today Date" with a space in it and use it later in my Data Flow.
So I would need something similar to
If value = "TodayDate" Then
value - "Today Date"
Else
.....
How do I do that
Thanks.