Post reply

FTP Task

  • September 9, 2003 at 3:24 pm

    #106589

    I need to be able to list the files on an ftp server and then pass just 1 filename out of the list to my ftp task in DTS. This way I just download the 1 file that I need. Does anyone have any insight on how to accomplish this?

  • September 9, 2003 at 5:43 pm

    #473336

    How do you currently determine which file to FTP?

    If you store the file name in a global variable, you can use the Dynamic Properties task to change the appropriate property of the FTP task.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 9, 2003 at 6:40 pm

    #473341

    I just started working on the DTS package so as of now I manually specify the name since the name changes so much.

  • September 9, 2003 at 7:07 pm

    #473344

    Ok, so for the moment, create a global variable. Set the value of the global variable to the file you want.

    Add a dynamic properties task to the package.

    Click Add...

    Select your ftp task from the list of tasks on the right.

    Select the property SourceFilename on the left.

    Click Set...

    Choose 'Global Variable' from the Source combo box.

    Choose your global variable from the 'Variable' combo box.

    Click OK and OK

    Now you should be able to change the value of the global variable to whatever you need and have that file FTP'd.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

Viewing 4 posts - 1 through 3 (of 3 total)

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