Profiler Trace Source

Your rating: None Average: 2 (1 vote)

Overview

Source data flow component for loading profile trace information. It 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 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
  • CozyRoc.SSISPlus
  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.SmoEnum
  • System.XML
  • Microsoft.SQLServer.ManagedDTS

ScriptMain