Exporting Data to a textfile with a dynamic filename.

[knabet]

I need to dump data from a table to a comma delimted text file. I can do that.. the question is can I do it to a textfile with today's date in the filename.

For example would like to have the filename be
1-17-2001.csv and at 12:30am when the DTS runs the new filename would be 1-18-2001.csv ( the format of the date may not be exactly this, but should be able to change that at anytime )

I've completed this task by basically using a .bat file to rename the file once its created. But that involves 2 schedules and not using SQL Server to do it all which I'd like to do.

Thanks in advance for any help.

 

[avn]

within a stored proc:

use 'bcp' out... then create a variable @currdate-(representing its filename); you might as well implement the dateadd function (to increment date in filename).

avn