SSIS Derived Column Casting to DT_STR

2 votes

1 answer

24557 views

                          Why can't I get this to cast as a DT_STR - the data source is WSTR, but shouldn't this cast make the output DT_STR?

(IPUNSPSC) =="**no_UNSPSC_available**" ? (DT_STR,20,1252)NULL(DT_STR,20,1252) : (DT_STR,20,1252)TRIM(IPUNSPSC)

Asked by Steve Britton (67 rep)

Jul 5, 2017, 05:05 PM
Last activity: Jun 26, 2018, 01:59 AM

SSIS Derived Column Casting to DT_STR

Related Questions