Probably a basic SSIS question ...
可能是一个基本的SSIS问题……
I have a Loop Container which loops over a directory of Excel File and imports and moves each individual file to another folder ( About 380 Excel Files).
我有一个循环容器，它循环遍历Excel文件目录并导入每个文件并将每个文件移动到另一个文件夹(大约380个Excel文件)。
Please no comments about not using a robust file format for importing that volume of files in SSIS, as I completely agree.
请不要在我完全同意的情况下使用一个健壮的文件格式来导入SSIS中文件的数量。
The problem I have is that many of the Excel Files, about 80 had Excel File import Errors and I had to stop , put the problem file aside and restart about 20 times before I could identify all the problem Excel files to manually fix.
我的问题是，很多Excel文件，大约80个都有Excel文件导入错误，我必须停止，把问题文件放到一边，然后重新启动大约20次，然后才能找到所有的Excel文件手动修复。
So is there any way I can get the process to skip problem Excel Files that cause the Excel source in the Data Flow to go RED, and just process all the good files?
那么，我是否可以让流程跳过导致数据流中的Excel源变为红色的问题Excel文件，只处理所有好的文件?
Finding a solution to this will save me at least an hour when running the process ?
找到一种解决方案可以在运行过程时至少节省一个小时?
This is SSIS 2008.
这是2008年SSIS。
1 个解决方案
#1
1
You can achieve this by setting the task property ForceExecutionResult to Success. If you are looking for something more robust
您可以通过设置task property forcetionresult以获得成功。如果你在寻找更健壮的东西
#1
1
You can achieve this by setting the task property ForceExecutionResult to Success. If you are looking for something more robust
您可以通过设置task property forcetionresult以获得成功。如果你在寻找更健壮的东西