New to Activate data clears fields
I have a transformation which contains a number of fields that are set as a constant value of 0 (have left them unmapped previously) and an End Routine that populates them with a 1 depending on certain criteria.
When DTP'd into a DSO, and prior to activating, these field values of 1 can be seen via New data on the Contents Tab of the DSO.
When the package is activated, all the fields in Active data are cleared!
Any explanation for this phenomenon?