December 28, 2003 at 5:23 pm
Thank you in advance to your help.
I am running a DTS wich creates several flat text files. After these is completed the files are zipped into a specific zip name. No problem there, but now the client wants to insert a date, read from a table, into the zip file name. I have tried several options, but none of them seems to work as I need.
After several trials, I contacted winzip to see if they have some suggestion, but I haven't have any luck with them either. I hope anyone here had to work on something similar and can help me with this. Any help or suggestion will be appreciated.
December 29, 2003 at 9:35 am
I'd rename the file after it was created with a simple xp_cmdshell 'ren oldfile.zip newfile_date.zip'
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply