waheedrous.wordpress.com
SSIS – Global replace for all columns using a script component | Waheed Rous
https://waheedrous.wordpress.com/2014/02/24/ssis-global-replace-for-all-columns-using-a-script-component
February 24, 2014. SSIS – Global replace for all columns using a script component. Sometimes while in the data flow you need to apply the same function on all the columns in the data flow or all columns have a specific data type, for example:. Remove all commas and new lines from text columns before exporting them to a CSV file. Replace text “Null” with Null value when loading data from an excel file that has nulls as text in it. Convert all strings to upper or lower case. etc…. I’m skipping all co...
SOCIAL ENGAGEMENT