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?
You might also want to check the option to Keep Null values on both source and destination connection (if available)