How to change empty strings to NULLS

Question

I'm using SQL Server 2008 Integration Services (SSIS) and would like change empty strings on one of my columns (Unicode string(DT_WSTR-50)) to NULLs. I found some related posts but that doesnt seem to work.

I tried: Column == "" ? NULL(DT_WSTR,50) : Column

user2460074 · Accepted Answer · 2016-02-10 08:53:12Z

1

How about this :

LEN(LTRIM(RTRIM([ColumnName])))==0 ? NULL(DT_WSTR, 10) : LTRIM(RTRIM([ColumnName]))

answered Feb 10, 2016 at 8:53

user2460074

1,2573 gold badges13 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to change empty strings to NULLS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related