How to convert blank into null in ssis
error-handling, sql-server, ssis
Solution
You might also want to check the option to Keep Null values on both source and destination connection (if available)
Problem
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?