The transformation is simple to check empty and replace with "NULL".
Code: Select all
Seq -->Trasformer --> DB1 (10 fields)
|
DB2 (278 fields )
Now if I change the design to look something like below:
Code: Select all
Seq -->Trasformer1 --> DB1 (10 fields)
|
Transformer 2
|
DB2 (278 fields )
in Transformer2 I check EmptyToNull for 158fields and rest 120 fields are straight move.
With the second design the code gets compiled and it runs on both DEV and TEST server.
Does anyone know what could be the reason?