DTS Output file name

[Gweener]

Hi All,

Doing a simple DTS to execute a SQL task and then output the results to a text file.

Can do all this OK - EXCEPT, this is to be a daily task and I want to be able to control the naming convention of the file i.e. to have a different name each time it executes (integrate the date for example).

Can anyone advice on the best way to achieve?

Many thanks

 

[fredericofonseca]

what SQL Server version used.
If 2k you may be able to use dynamic variables, if other you can always execute a final sql step where you execute a command line with a rename from a fixed filename to your daily name.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[SQLDenis]

Take a look at the filesystem object
or take a look here (

http://www.sqldts.com/default.aspx?292)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/