Post reply

SSIS Excel Source Versus Unicode FlatFile Source

  • May 26, 2014 at 12:04 pm

    #308390

    when we point a unicode flatfile(DT_WSTR),external columns remain DT_WSTR, but output columns automatically turn to DT_STR, there is no need to use a DataConversion to convert from DT_WSTR to DT_STR

    whereas

    for excel source(DT_WSTR) external columns will not be converted to DT_STR output columns automatically

    we need to use a DataConversion Transformation to Convert DT_WSTR to DT_STR

    any specific reasons?

  • July 18, 2014 at 4:38 pm

    #1730798

    Because the data types in Excel do not fit snugly with those of SSIS. Also you have a General type (text) and can represent a number as well as a string. Everything from Excel gets automatically tagged as unicode so you the developer have to resolve the ambiguities.

    ----------------------------------------------------

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply