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?

uwe
  • 113
  • 5

1 Answers1

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.

mrdenny
  • 27,106
  • 2
  • 44
  • 81