英文:
SQL SSIS Script Task Using C# to Process All Rows
问题
在SSIS中，我有一个脚本任务，它接收包含6个值的10行数据：
- Row.WorkOrderID
- Row.WorkOrderProductID
- Row.BatchNo
- Row.OldQty
- Row.NewQty
我需要提取所有具有相同的 Row.WorkOrderID 和 Row.WorkOrderProductID，但 Row.NewQty 与 Row.OldQty 不同的记录。
我知道SSIS脚本任务的 ProcessInputRow 方法逐行处理数据。在我的情况下，这只能在 PostExecute 方法中完成吗？
英文:
In SSIS, I have a Script Task that takes in 10 rows of data, containing 6 values
- Row.WorkOrderID
- Row.WorkOrderProductID
- Row.BatchNo
- Row.OldQty
- Row.NewQty
I need extract all records that have the same Row.WorkOrderID and Row.WorkOrderProductID, but different Row.NewQty compared to Row.OldQty.
I'm aware that SSIS Script Task ProcessInputRow method processes row by row. In my case, can this only be done in PostExecute method?
答案1
得分: 1
考虑使用条件拆分来执行任务，如果需要的话再进行合并。如果某些任务不能通过SSIS提供的转换完成，才考虑使用脚本任务。由于脚本任务逐行处理数据，对于大型数据而言速度较慢。请查看在条件拆分中使用的条件：
英文:
Consider using conditional splits to do the job and merge again if needed. Script task is only as a last option if something can't be done by the transforms that SSIS has, and because Script task process row by row it is slow for large data.
Check out the condition to use at conditional split:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论