convert string allow null col to int?

2 votes

1 answer

1337 views

sql-server-2008 ssis ssis-expressions

                          I want to convert string to int my string type  [DT_WSTR] and my expression 

    ISNULL(col) || TRIM(col) == "" ? (DT_I4)0 : (DT_I4)col
 I get this error 
[Derived Column ] Error: The conditional operation failed.

Asked by NinjaDeveloper (245 rep)

Sep 19, 2014, 07:44 PM
Last activity: Sep 23, 2014, 02:48 AM

convert string allow null col to int?

Related Questions