从SSIS中的多个FTP文件夹下载文件 [英] Download files from multiple FTP folders in SSIS

问题描述

是否有方法可以使用SSIS从FTP位置的多个文件夹中提交dlownload。我知道从一个特定的文件夹下载文件。但是有多个文件夹需要SSIS在FTP位置进行遍历

你的包中变量的源文件夹。这将允许您为每个变量设置一个循环容器，并将每个路径作为参数传递给您的ftp任务。会有一些开销，因为你会建立并销毁每个循环的ftp连接，但这会让你得到一个参数化的解决方案。

Is there a way to dlownload filed from multiple folders in FTP location using SSIS. I know to download files from a particular folder. But there are multiple folders that I want the SSIS to traverse through on FTP location

解决方案

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.

这篇关于从SSIS中的多个FTP文件夹下载文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！