Post reply

DTS FTP Problem with SourceFileName

  • October 13, 2004 at 8:12 am

    #86687

    My DTS package is intended to upload medical data on a daily basis. An ActiveX script calculates the current day's file name, then a Dynamic Properties Task feeds the new name to an FTP Task through a global variable. Each component works properly, but when attached by workflow connectors and run together, the FTP bombs with the message: "Invalid string format for source file names." An example of the source file name would be "2004.10.12.CDRLabs". I have moved the text to the front, enclosed all in single quotes, and replaced the dots with "_", but nothing seems to work. What are the criteria for SourceFileName? There appears to be no documentation for this. Help!

  • October 13, 2004 at 10:51 am

    #526546

    Not sure what the criteria is, but I've used underscores with no issues. Tried running it all together, no separators?

  • October 13, 2004 at 11:22 am

    #526556

    Thanks, Steve.

    Yes, I've tried it with no separators and no spaces. Same error. Perhaps there is another way to handle FTP name changes? Maybe I should go ActiveX Script all the way?

  • October 14, 2004 at 6:26 am

    #526690

    Have you tried eliminating the quotes altogether?

  • October 14, 2004 at 6:42 am

    #526695

    Hi Ron, and thanks. Yes, I've tried it with no quotes, double quotes and single quotes.

  • October 14, 2004 at 8:23 am

    #526733

    Eureka!

    The answer appears to be:

    1. The file name does have to be enclosed in single quotes,

    2. Five characters must follow the close quote. They are ;";";. Single quotes will not do, here. They must be double quotes. Consequently, the correct calculated SourceFileName to run FTP from a Dynamic Properties Task is 'Filename' & CHR(34) & CHR(59) & CHR(34) & CHR(59).

    No doubt these characters are taking the place of optional commands. But what those commands might be appears to be undocumented as far as I can make out.

    Thanks for your help.

  • May 3, 2005 at 8:39 am

    #556539

    I found another site that said the expected format was [name];[date];

    You can skip the [date] and but can't skip the semi-colons

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply