[FIXED] How to convert blank into null in ssis

Issue

I am extracting data from excel in ssis. One of the excel column contain blank values. so i need to replace blank value with null otherwise my package is going to fail. Any suggessions?

Solution

You might also want to check the option to Keep Null values on both source and destination connection (if available)

Answered By - Thony

Answer Checked By - Mary Flores (PHPFixing Volunteer)