November 28, 2005 at 8:19 am
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
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 28, 2005 at 9:28 am
How do I set that up in DTS?
Thanks for the reply
November 28, 2005 at 9:32 am
November 28, 2005 at 10:45 am
Thanks anyway
November 30, 2005 at 7:13 am
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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply