Recently I was debugging a job where we are loading data from a .csv file to table. The problem that was happening is that the Character fields had spaces shown as blocks and not spaces.
Upon checking 2 observations were made:
1) The Character field had the Extended property set to Unicode.
2) Trim function was performed on the column in Transformation stage and assigned back to a Character field.
1) The Character field had the Extended property set to Unicode.
2) Trim function was performed on the column in Transformation stage and assigned back to a Character field.
These 2 were causing the issue.
Once the Unicode option was changed to Blank and the trims were removed from Transformation stage, the Unicode character i.e. Blocks disappeared.
Once the Unicode option was changed to Blank and the trims were removed from Transformation stage, the Unicode character i.e. Blocks disappeared.
Reverting either of the observation caused in blocks.
One more observation: Blocks did not appear when a Trim was performed on a Character field but assigned to a Varchar field.
:)
No comments:
Post a Comment