Ftp Download in SSIS

  • Guys/Girls

    Can some body point me in the right direction to get the first part of my ssis package to work.

    I need to get two files off a ftp site, i can get it working with one just point the ftp task at the file. But i need to get two of the ftp site.

    The two files i need are uk.txt.zip and ir.txt.zip and are in a directory called /gets

    Any help would be great

  • Didn't reliase i could just use this as the variables vale = /gets/*.zip

    Is there any disadvantages to this ?

  • you answered how to do it.

    the only downside i can think of is if a different zip file was placed in the source ftp site in addition to the two you have listed, that file would come over in the ftp process as well.

    however, the rest of your package should be setup to handle that scenario should that occur.

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

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