DSXchange

thank you, nice to be on-board
that's an easy enough solution
thank you kindly

Hi I use CFF (Complex Flat File) to populate a MS SQL DB with hundreds of CFF files. The issue I have is that the CFF use a Character native data type for string values and the trailing blanks are not trimmed automatically. Options I have is to use the Datastage TRIM function or set ANSI_PADDING OFF...