Remove null records from EXCEL source using SSIS
Step 1: Drag and drop excel source Step 2: Edit Excel source and create new file connection Select excel source file from local system Select required sheet from excel file Click on preview to view existing data Step 3: Drag and drop data reader destination And enable data viewer as shown in bellow Execute task Step 4: For eliminating null records , need to use conditional split transformation Step 5: Edit conditional split transformation Provide condition as shown in bellow ISNULL(PersonId) || ISNULL(FirstName) || ISNULL(LastName) Step 6: Make connection between conditional split transformation and data reader destination Select output type as shown in bellow Step 7: Again enable data viewer Step 8: Execute task