Convert Blank to Null - SSIS

Add dervied Column to package Add this expression replace [Column Name] with your column name and make sure to set your string length (50) accordingly (DT_STR,50,1252)(TRIM([Column Name]) == "" ? (DT_STR,50,1252)NULL(DT_STR,50,1252) : [Column Nmae])

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.