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

  • Good day Guys,

    The solution of converting from DT_NTEXT to DT_WSTR AND from DT_WSTR to DT_STR will work. As long as tet being converted does not exceed DT_STR 8000 characters. Which is the problem that I'm getting. 🙁

    Any work around that issue?!