共用方式為


PipelineComponent.AddErrorOutput 方法

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

命名空間:  Microsoft.SqlServer.Dts.Pipeline
組件:  Microsoft.SqlServer.PipelineHost (在 Microsoft.SqlServer.PipelineHost.dll 中)

語法

'宣告
Public Sub AddErrorOutput ( _
    strOutputName As String, _
    lInputID As Integer, _
    lExclusionGroup As Integer _
)
'用途
Dim instance As PipelineComponent 
Dim strOutputName As String 
Dim lInputID As Integer 
Dim lExclusionGroup As Integer

instance.AddErrorOutput(strOutputName, _
    lInputID, lExclusionGroup)
public void AddErrorOutput(
    string strOutputName,
    int lInputID,
    int lExclusionGroup
)
public:
void AddErrorOutput(
    String^ strOutputName, 
    int lInputID, 
    int lExclusionGroup
)
member AddErrorOutput : 
        strOutputName:string * 
        lInputID:int * 
        lExclusionGroup:int -> unit
public function AddErrorOutput(
    strOutputName : String, 
    lInputID : int, 
    lExclusionGroup : int
)

參數

  • strOutputName
    型別:System.String
    Specifies the name of the output.
  • lExclusionGroup
    型別:System.Int32
    Specifies the exclusion group of the output.

備註

This helper function adds a new output to the IDTSOutputCollection100 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 使用資料流程元件中的錯誤輸出.

範例

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

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

      IDTSOutput100 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 IDTSInput100 = ComponentMetaData.InputCollection.New()
    input.Name = "SampleComponentInput"

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

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

  End Sub

請參閱

參考

PipelineComponent 類別

Microsoft.SqlServer.Dts.Pipeline 命名空間