You could pass the CSV data into a Data Manipulation step where by you set a value to the LEFT(charfield,255). You then push the new value into the CMDB.
Do you happen to know which specific spoon step to use? I tried String operations and String Cut , which seem to be no brainer selections, but they don't seem to do what i want.
In looking at String Operations ... you can set the trim to left, but you can't seem to specify the # 255 anywhere?
Option Definition Step name The name of this step as it appears in the transformation workspace. In stream field Designate the field to transform. Out stream field Designate the name of the field to be created. Trim type Designate the trim type: none, left, right, or both. Lower/Upper Designate upper or lowercase. Padding Designate left or right padding. Pad char Designate the padding character. Pad Length Designate how long the padding will be. InitCap Transform to initial capitalization. Escape Define to Escape or Unescape XML, HTML, use CDATA or Escape SQL. Digits Designate whether to return remove, or do nothing to digits. Remove Special character Designate a special character to remove.
Perfect, thank you !