"Nigel Rivett" wrote:

> Why not do it from a stored procedure - it's easier and you have the command
> file to check or develop independantly
> see
>
> http://www.mindsdoor.net/#FTP
>
> "Tim L" wrote:
>
> > I'm trying to pull files from an ftp site. Part of the file name is the
> > current date. I have put together an Active X script task to generate the
> > file name, but cannot get the dynamic properties task to use the generated
> > file name. I read that following the file name with 3 semi-colons (;;;)
> > would work, but that did not work in this case.
> >
> > The general form of the file name is: Type_IDnum_mm-dd-yyyy.log.gz I have
> > the first part of the file name and the file extension in global variables; I
> > use a query to pull the date. The ActiveX Script concatenates the file name,
> > date, and extension into a global variable. I use the generated global
> > variable to set the file name property in the dynamic properties task.
> > Unfortunately, the file name comes up as "not displayable" and I get the
> > following error when I try to execute the package:
> >
> > Invalid string format for source file names.
> >