Using NullToValue() at a job level

ggarze · Post by **ggarze** » Thu Jun 25, 2015 1:16 pm

If i have a job like database --> transform --> database, instead of doing a NullToValue() on almost every column in the transform, is there a way to do this at the job level so that every null value in any column will be converted to a non-null value of my choice?

Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Jun 25, 2015 4:03 pm

No, but you can multi-select the column derivations then choose Derivation Substitution from the right-click menu. By this means you can change as many derivation expressions as you wish at one time.

ggarze · Post by **ggarze** » Fri Jun 26, 2015 7:52 am

Thanks Ray, that will work