Automatically export SQL query to a csv or txt file

Question

I'm currently using SSRS to export reports. However my client would like to have a url to download or file dynamically produced possibly on a schedule or on command.

What would be the best way of doing this without trying to force SSRS to do more than it can?

Is there a simple way. I am new to SQL.

K Richard · Accepted Answer · 2014-04-15 20:04:52Z

1

Why not use the subscription and delivery services within SSRS (http://technet.microsoft.com/en-us/library/ms159762.aspx)? The nice thing about this is it will allow you to choose a number of convenient render options. You can have it email or send to a shared file location. If the client is asking for this to be produced on demand, then wouldn't the export option within SSRS be sufficient?

answered Apr 15, 2014 at 20:04

K Richard

2,0042 gold badges24 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shreyos Adikari · Accepted Answer · 2014-04-15 19:59:10Z

0

You can use this query :

SQLCMD -S YourSQLServer -d YourDatabase -U YourUserName -P
YourPassword -Q “Your Query” -s “,” -o “C:\Yourfilename.csv”

Now you can go to your file location and open the file and you will see that new csv file created there. When you open the csv file you will notice the results of the query.

Check http://blog.sqlauthority.com/2013/03/05/sql-server-exporting-query-results-to-csv-using-sqlcmd/ this for more details.

answered Apr 15, 2014 at 19:59

Shreyos Adikari

12.9k19 gold badges76 silver badges82 bronze badges

Collectives™ on Stack Overflow

Automatically export SQL query to a csv or txt file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related