开发者

How do I transfer all files and subdirectories in a folder via FTP in SSIS?

开发者 https://www.devze.com 2023-02-09 12:46 出处:网络
Running SQL Server 2008, in SSIS appending an * to the folder path got all the loose files, but doesn\'t move the subdirectories.I could set up a ftp create directory task and a ftp transfer task for

Running SQL Server 2008, in SSIS appending an * to the folder path got all the loose files, but doesn't move the subdirectories. I could set up a ftp create directory task and a ftp transfer task for each of the subdirectories, but I was looking for a less tedious, more robust, way to h开发者_C百科andle this. Any suggestions?


you can always rely on a command-line ftp client that you know that can handle the whole operation on a single step (e.g. winscp).

Then you call it via the execute process task component.


I only had three subdirectories so I bit the bullet and just did the 3 creates and moves for their files, seemed less a hassle than adding a new program into the mix. Although I would certainly consider that if I had a bigger job to do.

0

精彩评论

暂无评论...
验证码 换一张
取 消