1

We are exporting 100,000+ rows from a SQL Server 2005 DB to a text file. We have a web script setup to read all rows and then write the text file and it takes over 5 minutes to complete that script.

How can we set it up to export directly from SQL server to a csv file and schedule that daily?

asked Nov 30, 2011 at 3:26

1 Answer 1

5

Yes, no problem. Use BCP (which is a command line tool) to export the data. Once you have the parameters the way you like, schedule this as a SQL Agent job.

answered Nov 30, 2011 at 4:34

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.