Script task to process data flow result into control flow.
This script task is elegant solution over the issue how to process the result of data flow transformation in SSIS control flow enumeration container. It implements wrapper over standard DataReader destination component. Each enumeration is of type IDataRecord.
You may download sample SSIS package from here. The result of each enumeration is printed in the execution results window.
The script has the following parameters:
- PackageConnection - Package connection manager (Connection).
- DataFlowDestination - DataReader Destination component to wrap.
- EnumeratorVariable - Package variable where result enumerator is stored.
To extract IDataRecord fields information into SSIS variables, check Data Record To Variable Task script.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.