Text File Export Name

[NEveritt]

Is there a quick way to have a DTS export running every day, but not wipe over the file it creates? I.e. to add a date parameter to the file name.

Your help is appreciated, Im new to this.

N

 

[MaffewW]

I believe you can do it in SQL 2k with a Dynamic Properties Task, I havent used this as we are still on SQL Server 7, though we get round it by having an execute SQL task run on success of the file export by using xp_cmdshell, it works ok though I know a lot of people have xp_cmdshell restricted

this is the example we use

declare @renameexp varchar(200)
select @renameexp = 'rename \\server\share\export' +' export'+replace(convert(varchar,getdate(),3),'/','')+'.csv'
exec master..xp_cmdshell @renameexp

 

[tlbroadbent]

How can I change the filename for a text file connection?

http://www.sqldts.com/default.aspx?6,101,200,0,1

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm