DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
No votes yet


Overview

Data flow source component for loading profile trace information.


Setup

The script has the following parameters:

  • Source - specifies trace information source. It can be file, table or server.
  • File - specifies file connection manager to trace file (.trc).
  • Server - specifies profiler trace server.
  • Database - specifies database containing profiler trace table.
  • Table - specifies table containing profiler trace.
  • Profile - specifies profiler trace profile (.tdf).

Requirements

Depends on COZYROC Script Component Plus 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
  • CozyRoc.SSISPlus
  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.SmoEnum
  • System.XML
  • Microsoft.SQLServer.ManagedDTS

ScriptMain