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
sudhanva
Ten Centuries
Points: 1343
More actions
May 1, 2011 at 7:58 am
#1318165
Two steps involved in this:
1. Convert DT_NTEXT to DT_WSTR
2. Convert DT_WSTR to DT_STR
Thats it.