How to Set a Value to Null

 

i working data stream date column either comes in date or comes in word na. want change na values nulls. how do this?

you'll need use conditional expression operator http://msdn2.microsoft.com/en-us/library/ms141680.aspx and null expression operator whatever data type you're using.

 

you'll end looks this:

 

code snippet

code snippet

[col] != "na" ? [string-col] : (dt_wstr, 255)null(dt_wstr, 255)

 

 

 

 

you may want take here: http://blogs.conchango.com/jamiethomson/archive/2006/10/12/ssis_3a00_-nulls-in-expressions-gotcha.aspx

SQL Server  >  SQL Server Integration Services