RTRIM in DTS package

• n-igma

  Old Hand

  Points: 308

  More actions

  April 9, 2002 at 7:42 am

  #78437

  Hi All,

  When using a query in a dts package, functions parse as valid SQL, however usually the dts package fails. Can someone please tell me how to use functions in a query for a dts package.

  SELECT RTRIM(title), RTRIM(firstname), etc... fails.

  TIA

  Phil Ewington.

• n-igma

  Old Hand

  Points: 308

  More actions

  April 9, 2002 at 8:16 am

  #426863

  OK, all resolved. Seem to always forget this one ;o)

  RTRIM(colname) 'alias'