Hi,

I am upgrading a few sql 200 dts packages to ssis. In one old package,
an activex Script task creates a global variable for a file name. The
file name is something like: "abcd_062606.csv". This file is then
downloaded via ftp and then imported into a table.

My question is whats the best way to this in SSIS. Do I need a Script
Task in SSIS at all? Can I use expressions to set the file name both
while importing by ftp and then the source for Data Flow Task. Some
help with the actual expression to generate the file name and where/how
to assign it to get the package to work would be appreciated.

Asim.

Sorry, posted in the wrong forum.