Home Forums Data Warehousing Integration Services SSIS DT_NTEXT to DT_STR conversion failure unicode and non-unicode Excel RE: SSIS DT_NTEXT to DT_STR conversion failure unicode and non-unicode Excel
getoffmyfoot
Hall of Fame
Points: 3338
More actions
February 9, 2012 at 1:37 pm
#1445276
The solution to your problem, johnnyk, is the same. Convert the DT_TEXT field to a DT_STR. If the field is unicode, convert the DT_NTEXT to DT_WSTR, then convert the DT_WSTR to DT_STR.
Hope that helps...