It returns a null value of a requested data type:
http://msdn.microsoft.com/en-us/library/ms141758.aspx
I think that you wont use it that much in the Conditional Split, but more often in the Derived Column.
For example to return a null value instead of an empty string:
[myColumn] == "" ? NULL(DT_STR, 10, 1252) : [myColumn]
In the Conditional split you could use the ISNULL expression:
http://msdn.microsoft.com/en-us/library/ms141184.aspx
Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com |
Twitter