Hi Amir
There is to_char function in BODS which converts number/date into varchar.
to_char(date or numeric expression,format)
You dont need to use any function. Just map the input to output schema with output as varchar(40), DI will do the rest. The value will be automatically converted to varchar.
Arun
I would be cautious when using implicit datatype conversion as it can stop Data Services performing optimizations, for example full push-down. There's a reason Data Services gives a warning when datatypes are not matched.
Explict conversion use to_blah or cast should be used for production quality code.
Michael
