What are null funtions in the ssis expression
-
Saturday, February 09, 2013 8:50 AM
Hi,
What are null funtions in the ssis expression(conditional split)?How can we use that?
All Replies
-
Saturday, February 09, 2013 8:55 AMModerator
It returns a null value of a requested data type:
http://msdn.microsoft.com/en-us/library/ms141758.aspxI 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.aspxPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
- Marked As Answer by NikkRED Saturday, February 09, 2013 9:31 AM
.png)
