SSIS从多个子文件夹中获取文件(SSIS Get files from multiple subfolders)

 如何从多个FTP子文件夹中检索文件？ 
 
 我有下一个结构： 
 
 
 
 mainFolder 
  
 
   
 subFolder 1 - >文件1，文件2，文件...（超过100个子文件夹） 
    
 
     
 子文件夹2 - >文件1，文件2，文件...（超过100个文件夹） 
      
 
       
 子文件夹2 - >文件1，文件2，文件...（超过100个文件夹） 
 
      
 
    
 
  
 
 
 我找到了下一个答案 
 
 
 
 一种方法是将每个源文件夹放在包中的变量中。 这将允许您为每个变量设置一个循环容器，并将每个路径作为参数传递给您的ftp任务。 会有一些开销因为您将构建并销毁每个循环的ftp连接，但这将使您获得参数化解决方案。 
 
 
 但我不能“将每个源文件夹放在包中的变量中” 。 
 
 有人可以告诉我如何完成这项任务吗？ 

How to retrieve files from multiple FTP subfolders?
 
I have next structure:
 
 
 
mainFolder 
  
 
   
subFolder 1 -> File 1, File 2, File ... (more then 100 subfolders) 
    
 
     
subfolder 2 -> File 1, File 2, File ... (more then 100 folders) 
      
 
       
subfolder 2 -> File 1, File 2, File ... (more then 100 folders)
 
      
 
    
 
  
 
 
I found next answer 
 
 
 
One approach would be to put each of your source folders in variables within your package. This would allow you to set up a Loop Container for each variable and pass each path in as a parameter to your ftp task. There would be some overhead because you would be building and destroying the ftp connection with each loop, but that would get you to a parameterized solution.
 
 
But I cannot "put each of your source folders in variables within your package".
 
Can somebody show me how to do this task?

原文：https://stackoverflow.com/questions/34721019