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 ?
    Friday, October 04, 2013 11:27 PM


  • Hi,

    There is object variable type in SSIS packages but I don't know how would you pass the input value into that variable during package execution.

    Why don't you create a table where you would insert file names that have to be downloaded from ftp. Then run the package and the package would after successful download mark the row for that file in the table as downloaded.

    This way you would additionally get history of all downloaded files.

    HTH, Regards, Dean Savović,

    Saturday, October 05, 2013 5:18 PM