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