Post reply

Export data from a script

  • December 5, 2006 at 7:41 pm

    #116511

    I'm having a brain fade.

    Can someone please show me the syntax to export data to a csv file.  I currently have a script that creates a temp table it I want those results to export to a file on another server as csv.  I had this working in SQL 2000 as it is an option when you create a schedule, but that doesn't seem to be an option in 2005.

     

    Thanks for your help.

    Thanks,

    Kris

  • December 5, 2006 at 9:04 pm

    #676125

    Is it a question for SQL 2005 forum?

    _____________
    Code for TallyGenerator

  • December 5, 2006 at 9:34 pm

    #676131

    Yeah, Sorry.  I noticed after I posted, but I can't seem to find a T-SQL part of SQL2005 and I didn't want to post twice.  Where would recommend I post it? Under General or Admin?

    Thanks,

    Kris

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply