Automatic SQL Queries to dump data to folder

[kosta.triantafillou@gmail.com]

Hey everyone, trying to set up a SQL Query to run on a pre-determined
batch cycle that will automatically dump out specific table data to a
..csv file so that users can load the file into Excel right away, with
no manipulation or modification.

We are running SQL Server 2000. I am a novice SQL user. Any
suggestions?

[Erland Sommarskog]

Re: Automatic SQL Queries to dump data to folder

kosta.triantafi llou@gmail.com (kosta.triantaf illou@gmail.com ) writes:[color=blue]
> Hey everyone, trying to set up a SQL Query to run on a pre-determined
> batch cycle that will automatically dump out specific table data to a
> .csv file so that users can load the file into Excel right away, with
> no manipulation or modification.
>
> We are running SQL Server 2000. I am a novice SQL user. Any
> suggestions?[/color]

Best is probably to set up a job in Agent that uses BCP to bulk out
the data. Do you want the entire table, or only part of it?


You can also try the Export/Import wizard and see what it gives you.
(Never have used it myself, though.)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[JayCallas@hotmail.com]

Re: Automatic SQL Queries to dump data to folder

DTS is probably something you want to look at also. Like Erland's
suggestion, you package would be scheduled via SQL Agent.