Post reply

Saving to a csv file

  • November 28, 2005 at 8:19 am

    #89973

    Is there a way in query analyzer to save the results of a query to a csv file automaticall and have it overwrite any existing file thT is already there?

  • November 28, 2005 at 9:15 am

    #606138

    Semi-automatically.  Select Tools/Options/Results and set 'Results to File' as the 'Default Results Target' and set the Results output format to CSV.

    But you'll have to supply the filename and path.

    If you need to run the same query/extract repeatedly and automatically at scheduled times, DTS is probably the way to go.

  • November 28, 2005 at 9:28 am

    #606143

    How do I set that up in DTS?

     

    Thanks for the reply

  • November 28, 2005 at 9:32 am

    #606145

    A little difficult to discuss in a forum

    Check out this Tut

    http://www.sqldts.com/default.aspx?278

  • November 28, 2005 at 10:45 am

    #606166

    Thanks anyway

  • November 30, 2005 at 7:13 am

    #606718

    You can just use the import/export wizard.

    Just right click on the database and select all tasks, export data.

    Select a text file as destination.

    The rest is simple.

    Joachim.

Viewing 6 posts - 1 through 6 (of 6 total)

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