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

  • What are CommentsConv and Comments? Are you attempting to do this all in one derived column transform?

    Why not do one derived column transform to DT_WSTR and then a second to DT_STR?