Whats the best way to convert DT_NTEXT to DT_WSTR in Derived Colum Transformation.
Regards
A:
The problem here is that the max length of DT_NTEXT is 2^30 ~ 1.073 billion characters, while DT_WSTR max length is 4000 characters.
If all your fields are less than 4000, try Data Conversion Transformation and it may only raise a warning at design time. You would add this before of after the Derived Column Transformation.
Damir Sudarevic
2010-01-09 16:59:37