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 ?
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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.