Overview
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.
Setup
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.
Related technology
To extract IDataRecord fields information into SSIS variables, check Data Record To Variable Task script.
Configuration
To use this script, you would need to load it in COZYROC JavaScript Task. You can download the JavaScript file and browse to it via the "Import JavaScript code" button.
Data_Flow_Enumerator_Task.jsReady to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.