I was importing a CSV file with two columns (GPID, MemberOf) in a SSIS package when I found that GPID column might have null values and I don't need the entire row in my output if the GPID is null.
Solution:
One solution is to handle it via Script but why write code when Conditional Split is available.
Conditional Split has function ISNULL([Column Name]) which takes Column name to check if its null or not and returns the output if condition meets.
No comments:
Post a Comment