Wednesday, November 5, 2014

SSIS - Remove Rows with Null Values

Scenario:
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.