There are three aspects of the execution that can be measured: overall time of processing for the pipeline, average execution time per row, or per buffer. The value is always in seconds.
The script has the following parameters:
- MeasurementType - which aspect of execution time is measured. Possible values are
- StoreVariable - the variable in which to store the measured value. Could be floating point number.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.