What are null funtions in the ssis expression(conditional split)?How can we use that?
It returns a null value of a requested data type:
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:
Please mark the post as answered if it answers your question | My SSIS Blog:
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?