How do I export SQL data into a text delimited file?

• RubyRed

  Mr or Mrs. 500

  Points: 509

  More actions

  July 11, 2008 at 12:44 pm

  #70461

  How do I export SQL data into a text delimited file using SQL 2000? Need the script.

  SELECT date,customer_id,office,region

  FROM customer

  where date = '2008-07-10'

  ORDER BY date

  Need data in a text file like this:

  date,customer_id,office,region

  01/19/2008,70188,4,11

  01/21/2008,70188,14,28

  01/22/2008,70188,19,35

  01/23/2008,70188,12,34

  01/24/2008,70188,6,20

  01/25/2008,70188,19,42

  01/26/2008,70188,,8

  01/28/2008,70188,22,47

  01/29/2008,70188,9,36

  01/30/2008,70188,,24

  01/31/2008,70188,12,40

  02/01/2008,70188,16,42

  02/02/2008,70188,,11

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  July 11, 2008 at 1:24 pm

  #841776

  One time thing or a process?

  One time, use QA. run the query, right click the upper left, save as.

  Process, use DTS. The data export wizard will help you build the package.