Exporting data to CSV in Month and date format

Question

Exporting data to CSV in Month and date format

Ashif Shaikh

Default port

Points: 1445
More actions
July 1, 2014 at 5:19 am

#287410

Hi Experts,
I have a SP and can export the data to a .csv file, however I want the .csv file's name to be in month and date format whenever I run the SP or execute a job
Thanks,
Ashif Shaikh:-)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Could you give an example?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ashif Shaikh Default port Points: 1445 More actions · Answer 2

Hi,,

I am running the SP thorugh a SQL Agent job, as when the job runs it creates a file on H drive of the server. However every time it overwrites the .csv file with the same name ie 'new_file.csv' and I need it in this format 'new_file_2014061.csv', so that when it runs it should create a new file..

The jobs runs only once a month.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

I guess you can just adapt the code that creates the file.

Is it located in the sp?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ashif Shaikh Default port Points: 1445 More actions · Answer 4

no, for me the jobs is creating the output file from job- step -> advance -> output

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

Ashif Shaikh (7/1/2014)
no, for me the jobs is creating the output file from job- step -> advance -> output

Ah yes, you need to use jobtokens for that.

Use Tokens in Job Steps

Example:

http://social.msdn.microsoft.com/Forums/en-US/0ab84e38-bef6-42be-aee1-9ad0e19376cd/output-sql-server-agent-job-step-to-a-file?forum=transactsql

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

David Burrows SSC Guru Points: 65143 More actions · Answer 6

Koen Verbeeck (7/1/2014)
Ashif Shaikh (7/1/2014)
no, for me the jobs is creating the output file from job- step -> advance -> output
Ah yes, you need to use jobtokens for that.
Use Tokens in Job Steps
Example:
http://social.msdn.microsoft.com/Forums/en-US/0ab84e38-bef6-42be-aee1-9ad0e19376cd/output-sql-server-agent-job-step-to-a-file?forum=transactsql

Or if you only want YYYYMM then you could add a step and use ActiveX Script with Scripting.FileSystemObject to rename/copy the file

Far away is close at hand in the images of elsewhere.
Anon.