SQL SSIS Script Task Using C# to Process All Rows

Question

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?

dimis164 · Accepted Answer · 2023-02-08 08:18:31Z

1

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:

edited Feb 8, 2023 at 8:18

answered Feb 8, 2023 at 7:36

dimis164

1309 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL SSIS Script Task Using C# to Process All Rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related