Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Friday, November 11, 2016 12:08 AM
Points: 39, Visits: 225
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 Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, December 2, 2016 4:16 PM
Points: 988, Visits: 1,923
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.

----------------------------------------------------
How to post forum questions to get the best help
Post #1594267
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse