Row Count Transformation

Your rating: None Average: 2 (1 vote)
Script File: 
RowCountTransform.2005.scx
RowCountTransform.2008.scx

Overview

Collect information about processed number of rows and execution duration in data flow. It has the following parameters:

  • DurationVariable – specifies variable to store execution duration in seconds.
  • RowCountVariable – specifies variable to store number of rows processed.

Requirements

Depends on CozyRoc Script Component Plus component for implementing parameters user interface.
Requires installation of CozyRoc SSIS+ 1.4 library.

Library references

  • System
  • System.Data
  • Microsoft.SqlServer.TxScript
  • Microsoft.SqlServer.PipelineHost
  • Microsoft.SqlServer.DTSPipelineWrap
  • Microsoft.SqlServer.DTSRuntimeWrap
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus

ScriptMain

»