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
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, December 16, 2014 1:43 AM
Points: 38, Visits: 194
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
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



Group: General Forum Members
Last Login: Friday, December 19, 2014 6:42 PM
Points: 459, Visits: 1,065
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