SSIS – Transform All String Columns in a Data Flow Stream

For my string columns with a trim and conversion to null(//only operate on columns of type DT_STR or DT_WSTR)

To set the output data, use any of the Buffer.Set* methods, passing in the column index (i in the example) and new data (colData in the example) after applying the necessary transformation logic. To set a column null, use the Buffer.SetNull method, passing only the index to the column that needs to be null.

 

ssis-transform-all-string-columns-in-a-data-flow-stream