Passing multiple variables to a package in SSIS ?

  • I have a package which should download n number of files from only one FTP server. The server name will be a variable. I want to pass multiple (1,2,3, 10,000 etc) variables which contain filenames to this package and it should download all these files at a fixed location (for now).

    How do I pass it multiple variables ? Is there some kind of variable which can hold other variables ?

  • Try to pass the file names in one variable with a space between the file names. Watch out for string size overflow.

    Here are three alternative solutions:

    1)Use wildcards to download the files, for example *.csv, instead of file names.

    2)Instead of using the FTP task, call a ftp client using a bat command and a FTP script file, inside the ftp script, you can list each file. You can create a script to create the ftp script file.

    3)Use a fore each loop over the ftp task. You can create an object variable of type array with the file name, use a script to populate the array. However, you log on and off on the FTP server for each file.

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

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