在vb.net中迭代以获取文件

本文介绍了在vb中迭代以获取文件的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好， 我是ssis的vb脚本新手。我有两张桌子。我有源文件夹和目标文件夹。我必须将文件从源文件夹移动到目标文件夹。这些文件路径和名称在表中指定。建议我一个逻辑，以便我不应该处理目标文件夹中的文件。每月约有600个文件。我必须创建一个列表，使其包含目标文件夹中没有的文件。目的地路径将在其他表中

解决方案

请先阅读我的评论。 这是一个想法： Foreach循环容器 [ ^ ]

TN写道：

SQL Server Integration Services提供以下枚举器类型：

• ...
• Foreach 文件枚举器，用于枚举文件夹中的文件。枚举器可以遍历子文件夹。例如，您可以在Windows文件夹及其子文件夹中读取所有具有* .log文件扩展名的文件。
• ....

Hi All, I am new to vb scripting in ssis. i have two tables. i have source folder and destination folder.i have to move files from source folder to destination folder.these files path and name are specified in table. suggest me a logic such that i should not process the files which are there in destination folder. there are around 600 files coming monthly. i have to create a list such that it consists of files which are not there in destination folder. destination path will be there in other table

解决方案

Please, read my comment first. Here is an idea: Foreach Loop Container[^]

TN wrote:

SQL Server Integration Services provides the following enumerator types:

• ...
• Foreach File enumerator to enumerate files in a folder. The enumerator can traverse subfolders. For example, you can read all the files that have the *.log file name extension in the Windows folder and its subfolders.
• ....