Wednesday, November 5, 2014

SSIS - Remove Rows with Null Values

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.

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.

SPFx Docker image on Windows 10 VM

Please follow this GitHub link: