Tab delimited query results

• abaig

  Old Hand

  Points: 364

  More actions

  August 18, 2003 at 8:53 am

  #82217

  Hi,

  I am using DTS Transformation Data to run a query and then output the results to a DTS Destination file. In the properties "Select File format" of destination file I choose the following settings:

  1. Radio button => Delimited

  2. File Type => Unicode

  3. Row Delimiter => {CR}{LF}

  4. Column Delmiter => Tab

  5. Tag qualifier => None.

  The results in text file are displayed in a their respective columns but unfortunately for some reason 2 out of 4 columns have spaces in them instead of tab.

  Is there a way to write a sql statement so that all the columns are tab delimited? I tried using LTRIM and RTRIM functions but they seem to chop out my column names and cause DTS Transfor Data task to fail.

  Any help in this matter is appreciated.

  Thanks.

• NPeeters

  SSChampion

  Points: 12536

  More actions

  August 18, 2003 at 9:31 am

  #470290

  If your data contains spaces, they will be reproduced in the file.

  Otherwise, I don't see any problem with your approach.

• RD Francis

  SSCarpal Tunnel

  Points: 4867

  More actions

  August 19, 2003 at 1:30 pm

  #470463

  One other possibility that does come to mind - some text editors will converts tabs to spaces. Unlikely to be the problem, but a possibility.

  
  R David Francis