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, September 2, 2014 5:53 AM
Points: 38, Visits: 189
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


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:05 PM
Points: 355, Visits: 870
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