Results 1 to 2 of 2

Thread: Export data into Text file using ç Delimited

  1. 09-08-2005, 12:53 PM #1
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231

    Export data into Text file using ç Delimited

    Hi,
    I need to export data from SQL server 2000 database into text file uisng ç Delimited. Because my destination database will be teradata. Could you let me know if you have any method for this.
    Thanks
    Reply With Quote Reply With Quote
  2. 09-08-2005, 01:37 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Try bcp, you can spesify field delimiter with -t option and specify row delimiter with -r option.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules