1.  Create your new DTS package.
2.  Drag an FTP Task on the package.
3.  Enter in the Non-changing static information on the first tab (ftp site, username, password and dump location) - Dont select any files on the files Tab.  We'll set those dynamically.
4.  Close the Ftp Task
5.  Drag and ActiveX script Task on to the form.

[Sample Code:]
'********************
'  Visual Basic ActiveX Script
'****************************************
Function Main()
Dim oPkg
' Get current package instance
Set oPkg = DTSGlobalVariables.Parent
' Get existing FTP task by name
' Note, name may need to be changed to match your FTP task
Set oFTPTask = oPkg.Tasks("DTSTask_DTSFTPTask_1").CustomTask
dim fixDate
fixDate = Now()
fixDate = DateAdd("d", -1, fixDate)
dim sFilename
 sFilename = Right(Year(fixDate), 2)
 If Month(fixDate) < 10 Then sFilename = sFilename & "0" & Month(fixDate) Else sFilename = sFilename & Month(fixDate)
 If Day(fixDate) < 10 Then sFilename = sFilename &  "0" & Day(fixDate) Else sFilename = sFilename & Day(fixDate)
 sFilename = sFilename & ".zip"
 ' Set properties of FTP task
 oFTPTask.SourceFilename = "'" & sFilename & "';'dailyupdatefolder';''"
 '  Clean Up
 Set oFTPTask = Nothing
 Set oPkg = Nothing 
  Main = DTSTaskExecResult_Success
End Function
[end sample code]

a few notes on the code - the first bolded code (fixDate = DateAdd("d", -1, fixDate))
     I set the date back a day, because I'm after yesterdays files.
the second bolded code (;'dailyupdatefolder')  this is the file location on the ftp site that your file is sitting in.

Now setup the Workflow property for your FTP task to run after the ActiveX Script objects successful completion and you're all set.

things are at full speed at work now.  we've been working from a minimal amount of content provided by the design team and the site is really starting to come together.  a couple more resources will begin on monday and thats gonna help out a ton.  Especially on the store front.  I'm anxious to see what Jim and I will be able to drop into the whole solution.  He has a strong retail background so I'm sure that I'll be able to pick up alot of information from him.

Found out Ryans development secret today and now he's all mad about it.  He was slackin off all day, but yet he still has buttloads of code written.  How's he doin it?  And how can i cash in on the secret?  Then it occurs to me...He's prolly outsourcing his work assignments.  Nick tells him what to build and Ryan forwards that right on to his team.  Ryan probably makes like $65/hour, so it's not a big deal to pay some guy in New Delhi a buck fifty to pop off some code.  Man...wish i would have thought of it first.

Ryan's Development Team