Search/Replace Transform Editor
I was excited to check out the functionality of this when I thought I could apply changes to the values in my source dataset before loading to the target, which in my case is a SQL Server table. However, the only columns available for transforming are the log columns for the writeback process itself, as shown here (not…