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.

Any ideas?

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 was finally able to get this to work (the way I was trying it) by assigning
the file name to another global variable and using the new golbal variable in
the dynamic properties task.

Having said that, I appreciate the advice on using a stored procedure and
will investigate that as a longer-term, more elegant solution.

Thanks!

"Nigel Rivett" wrote: