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