r.szasza (11/24/2014)

---

halifaxdal (11/24/2014)

---

serg-52 (11/24/2014)

---

Have you tried to install

http://www.microsoft.com/en-us/download/details.aspx?id=13255

?

Note MS says it's for 2003R2.

Tried that already and it threw some other pre-req

I've found some interesting thread here:

http://stackoverflow.com/questions/3169220/export-query-result-to-csv-file-in-sql-server-2008

The .CSV file will have to exist already. If you're using headers (HDR=YES), make sure the first line of the .CSV file is a delimited list of all the fields.

I've tested it, if you have installed Microsoft.ACE.OLEDB.12.0 provider and the csv file is created with the column names before the OPENROWSET query run, it works fine.

However this will not solve that you want your csv to be named as the actual date and you have to create manually a new file every time.