Martin Griffiths
asked on
DT_WSTR dropping value before decimal point in SSIS
I'm trying to convert a value less than 1 e.g. 0.34 in to a string variable using DT_WSTR in a derived column transformation and it gets converted to ".34" rather than "0.34". How do I fix this please?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
use the above expression in your derived column by adding it as a new column and Map this column in your destination