The transformer in question maps the source columns to the target columns (ie the column names are completely different) with a small amount of manipulation. The target column meta data was imported. However the transform seems to pass not only the target columns but also the raw data to the db. I was able to confirm this by changing the Write Mode from Truncate to Replace. When I then checked the db it contained the nicely converted data but also all the columns and raw data from the source
![Shocked :shock:](./images/smilies/icon_eek.gif)
I have rebuilt the job again and the same thing is happening.
I am assuming that this is not normal behaviour, so if anybody else has had similar problems I would love to hear if you were able to solve it.
Thanks in advance
Shane