Saving a SQL query into a CSV file
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4810
Printed Date: 30 March 2026 at 12:16pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Saving a SQL query into a CSV file
Posted By: sdonatti
Subject: Saving a SQL query into a CSV file
Date Posted: 06 August 2003 at 3:08pm
|
My question is quite simple actually. I'm using SQL server Enterprise Manager trying to execute periodically a statement (using the agent) and i want to save the result in a csv file at a particular path. Can you give me a hand on this matter? 
|
Replies:
Posted By: michael
Date Posted: 06 August 2003 at 6:52pm
|
Use DTS to do your query and trans, to a csv then schedule the package. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |