I have an execute process task that performs the following:
cmd.exe /c wzunzip \\servername\share\companyname.20060410.zip c:\dir\ -o
Rather than hard code the date, is there a way I can automate this task to
pick off the latest zip file?

You will have to do the figuring out of the latest file yourself but you can
do this by looping over the files and stroring the values in a variable.
After that you can use this article to dynamically populate the Execute
Process task

How to manipulate the Execute Process task.
(http://www.sqldts.com/default.aspx?251)

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"SQLCat" <SQLCat (AT) discussions (DOT) microsoft.com> wrote

so, would I have to define GVs for each file of the month eg.
companyname.200604001.zip, companyname.200604002.zip, etc.? What about
additional months and dates?

"Allan Mitchell" wrote: