What are null funtions in the ssis expression

hi,

              null funtions in ssis expression(conditional split)?how can use that?

it returns null value of requested data type:
http://msdn.microsoft.com/en-us/library/ms141758.aspx

i think wont use in conditional split, more in derived column.

example return null value instead of empty string:
[mycolumn] == "" ? null(dt_str, 10, 1252) : [mycolumn]

in conditional split use isnull expression:
http://msdn.microsoft.com/en-us/library/ms141184.aspx

---

please mark post answered if answers question | ssis blog: http://microsoft-ssis.blogspot.com | twitter

SQL Server  >  SQL Server Integration Services