How to copy empty fields for only one filed in transform map from source to target

[Kanna12]

Hello every one,

I have one scenario, where we have lot of empty data in one field in source table. How can we copy empty field data  in target table. If i check mark "Copy empty fields in data source" It will impact on all fields  in transform map.

Can any one suggest how to copy one field empty values in target How to copy empty fields for only one filed in transform map from source to target table?

[Kieran Anson]

If you use a scripted field map, you can override the behaviour on a per-field basis. The below will set the value of the target field regardless of it's value (including empty values)