Поделиться через


PipelineComponent.AddErrorOutput Method

Adds an IDTSOutput90 object and marks it as an error output by setting the IsErrorOut property to true.

Пространство имен: Microsoft.SqlServer.Dts.Pipeline
Сборка: Microsoft.SqlServer.PipelineHost (in microsoft.sqlserver.pipelinehost.dll)

Синтаксис

'Декларация
Public Sub AddErrorOutput ( _
    strOutputName As String, _
    lInputID As Integer, _
    lExclusionGroup As Integer _
)
public void AddErrorOutput (
    string strOutputName,
    int lInputID,
    int lExclusionGroup
)
public:
void AddErrorOutput (
    String^ strOutputName, 
    int lInputID, 
    int lExclusionGroup
)
public void AddErrorOutput (
    String strOutputName, 
    int lInputID, 
    int lExclusionGroup
)
public function AddErrorOutput (
    strOutputName : String, 
    lInputID : int, 
    lExclusionGroup : int
)

Параметры

  • strOutputName
    Specifies the name of the output.
  • lInputID
    Specifies the IDTSInput90 of the error output.
  • lExclusionGroup
    Specifies the exclusion group of the output.

Замечания

Изменения образцов кода17 июля 2006 г.

This helper function adds a new output to the IDTSOutputCollection90 of your component. It sets the IsErrorOut property to true, and assigns the ExclusionGroup property specified by lExclusionGroup.

Error outputs are generally added during ProvideComponentProperties.

For more information, see Using Error Outputs in a Data Flow Component.

Пример

The following example shows how to add an error IDTSOutput90 to a component.

    public override void ProvideComponentProperties()
    {
      IDTSInput90 input = ComponentMetaData.InputCollection.New();
      input.Name = "SampleComponentInput";

      IDTSOutput90 output = ComponentMetaData.OutputCollection.New();
      output.Name = "SampleComponentOutput";
      output.SynchronousInputID = input.ID;
      output.ExclusionGroup = 1;

      this.AddErrorOutput("SampleComponentErrorOutput", input.ID, output.ExclusionGroup);

}

Public Overrides Sub ProvideComponentProperties()

    Dim input As IDTSInput90 = ComponentMetaData.InputCollection.New()
    input.Name = "SampleComponentInput"

    Dim output As IDTSOutput90 = ComponentMetaData.OutputCollection.New()
    output.Name = "SampleComponentOutput"
    output.SynchronousInputID = input.ID
    output.ExclusionGroup = 1

    Me.AddErrorOutput("SampleComponentErrorOutput", _
      input.ID, output.ExclusionGroup)

  End Sub

Синхронизация потоков

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

PipelineComponent Class
PipelineComponent Members
Microsoft.SqlServer.Dts.Pipeline Namespace