Hi,

I keep getting the error "Invalid string format for source file names" when
I execute a DTS FTP tesk. It seems to be intermittent. I can successfully FTP
from the site manually.

I set the properties via a dynamic properties task. I set the DestSite to be
c:\ftp and the SourceFileName to be TAG_ROW_20050812.TAG. I have tried the
values as both Global variables and constants but I keep getting the same
error. Every now and again it will work but the majority of times it fails
with the error above. Has anyone come across this before?

I am not passing the size or attributes parameters. Something else I
noticed, the file only appears in the destination portion of the Files tab of
the FTP task and not the source (This may be because I don't have LS
permission only GET permission - but it just struck me as odd and may be
unrelated).

Thanks,

Andy C

If you lookup SourceFilename Property in Books Online, you'll see that it
has a three part structured format.

'name';'path';'size';

Path and size can be empty, but you must maintain the format of quotes and
semi-colons.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Andy C" <AndyC (AT) discussions (DOT) microsoft.com> wrote

This is a quirky one:

When setting the file name you have to append the attributes and size to the
file name even though they are empty. This then fits nicely in the
Source/Destination file box.

What this means is that you should append ;'';''; to the end of the
SourceFileName property so the contents of my own SourceFileName global
variable look like TAG_ROW_20050812.TAG;'';''; This works a treat.

Hope this helps.

"Andy C" wrote: