Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Excel Source Versus Unicode FlatFile Source Expand / Collapse
Author
Message
Posted Monday, May 26, 2014 12:04 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 3:44 AM
Points: 38, Visits: 191
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?
Post #1574577
Posted Friday, July 18, 2014 4:38 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 1:04 PM
Points: 420, Visits: 996
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.
Post #1594267
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse