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

  • 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...