PipelineComponent 類別

Defines the base class that is used when developing managed data flow components.

繼承階層

System. . :: . .Object
  Microsoft.SqlServer.Dts.Pipeline..::..PipelineComponent
    Microsoft.SqlServer.Dts.Pipeline. . :: . .ScriptComponentHost

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

語法

'宣告
Public Class PipelineComponent
'用途
Dim instance As PipelineComponent

public class PipelineComponent

public ref class PipelineComponent

type PipelineComponent =  class end

public class PipelineComponent

PipelineComponent 型別公開下列成員。

建構函式

	名稱	說明
	PipelineComponent	Initializes a new instance of the PipelineComponent class.

上層

屬性

	名稱	說明
	BufferManager	Gets the IDTSBufferManager100 of the pipeline component.
	ComponentMetaData	Gets the IDTSComponentMetaData100 for a component.
	ErrorSupport	Returns an ErrorSupport object that lets the component raise errors, warnings, or other information events based on HRESULTs returned by Integration Services components written in native code.
	EventInfos	Gets the IDTSEventInfos100 collection of the PipelineComponent object.
	LogEntryInfos	Gets an IDTSLogEntryInfos100 collection of logging events that the component has registered.
	ReferenceTracker	Gets the IDTSObjectReferenceTracker100 associated with the component.
	VariableDispenser	Gets the IDTSVariableDispenser100 of the data flow component.

上層

方法

	名稱	說明
	AcquireConnections	Establishes a connection to a connection manager.
	AddErrorOutput	Adds an IDTSOutput100 object and marks it as an error output by setting the IsErrorOut property to true.
	BufferTypeToDataRecordType	Returns a managed data type based on an Integration Services data type.
	Cleanup	Frees resources and finishes the execution of the component.
	ConvertBufferDataTypeToFitManaged	Gets the appropriate Integration Services DataType from managed code.
	DataRecordTypeToBufferType	Gets the Integration Services DataType that corresponds to a managed type.
	DeleteExternalMetadataColumn	Deletes the external metadata column at the specified index from the collection of external metadata columns.
	DeleteInput	Deletes an IDTSInput100 object from the IDTSInputCollection100 collection.
	DeleteOutput	Deletes an IDTSOutput100 object from the IDTSOutputCollection100 collection.
	DeleteOutputColumn	Deletes an IDTSOutputColumn100 object from the IDTSOutputColumnCollection100 collection.
	DescribeRedirectedErrorCode	Provides error code information for a PipelineBuffer row added to an output buffer.
	Equals	(繼承自 Object。)
	Finalize	(繼承自 Object。)
	GetErrorOutputInfo	Returns the index and ID of the error output of the component.
	GetHashCode	(繼承自 Object。)
	GetType	(繼承自 Object。)
	idxOfBufferType	基礎結構。
	idxOfDataRecordType	基礎結構。
	Initialize	When overridden in a derived class, initializes a new instance of a custom data flow component.
	InsertExternalMetadataColumnAt	Inserts a new external metadata column into the collection of external metadata columns at the specified index.
	InsertInput	Adds an IDTSInput100 object to the IDTSInputCollection100.
	InsertOutput	Adds a new IDTSOutput100 object
	InsertOutputColumnAt	Creates a new IDTSOutputColumn100 object and inserts it into the IDTSOutputColumnCollection100.
	IsCompatibleNumericTypes	Determines whether two numeric data types are compatible to support a conversion from one type to the other.
	MapInputColumn	Establishes a relationship between an input column and a corresponding external metadata column.
	MapOutputColumn	Establishes a relationship between an output column and a corresponding external metadata column.
	MemberwiseClone	(繼承自 Object。)
	OnDeletingInputColumn	Deletes an IDTSInputColumn100 object from the IDTSInputColumnCollection100.
	OnInputPathAttached	Called when an IDTSInput100 object is connected to the component through the IDTSPath100 interface.
	OnInputPathDetached	Called when an IDTSInput100 object is disconnected from the component through the IDTSPath100 interface.
	OnOutputPathAttached	Called when an IDTSOutput100 object of the component is attached to a downstream component.
	PerformUpgrade	Upgrades the component metadata to the version of the component installed on the local computer.
	PostExecute	Called at the end of component execution, but before Cleanup.
	PreExecute	Called after PrepareForExecute, and before PrimeOutput and ProcessInput.
	PrepareForExecute	Called before PreExecute.
	PrimeOutput	Called at run time for source components and transformation components with asynchronous outputs to let these components add rows to the output buffers.
	ProcessInput	Called at run time when a PipelineBuffer from an upstream component is available to the component to let the component process the incoming rows.
	ProvideComponentProperties	Called when a component is first added to the data flow task, to initialize the ComponentMetaData of the component.
	RegisterEvents	When you are developing a custom data flow component, you override this method to create custom events.
	RegisterLogEntries	Registers the events that the component will log.
	ReinitializeMetaData	Repairs any errors identified during validation that cause the component to return VS_NEEDSNEWMETADATA at design time.
	ReleaseConnections	Frees the connections established during AcquireConnections. Called at design time and run time.
	RemoveAllInputsOutputsAndCustomProperties	Deletes each IDTSInput100 and IDTSOutput100 object from the component.
	SetComponentProperty	Assigns a value to a IDTSCustomProperty100 of the component.
	SetExternalMetadataColumnDataTypeProperties	Sets the data type properties of the specified external metadata column.
	SetExternalMetadataColumnProperty	Sets an individual property of an external metadata column.
	SetInputColumnProperty	Assigns a value to the IDTSCustomProperty100 of an IDTSInputColumn100 object.
	SetInputProperty	Assigns a value to the IDTSCustomProperty100 of an IDTSInput100 object.
	SetOutputColumnDataTypeProperties	Sets the data type properties of an IDTSOutputColumn100 object.
	SetOutputColumnProperty	Sets the value of an IDTSCustomProperty100 for an IDTSOutputColumn100 object.
	SetOutputProperty	Sets the value of an IDTSCustomProperty100 on an IDTSOutput100 object.
	SetUsageType	Creates an IDTSInputColumn100 object in the IDTSInputColumnCollection100 of the component and sets the UsageType property of the column.
	ToString	(繼承自 Object。)
	Validate	Verifies that the component is correctly configured.

上層

欄位

	名稱	說明
	s_STOCKPROPNAME_COMPFLAGS	Contains the name of the ComparisonFlags property of data flow components.
	s_STOCKPROPNAME_DELOUTPUTONPATHDETACHED	Contains the name of the DeleteOutputOnPathDetached property of data flow components.
	s_STOCKPROPNAME_EXCLGROUP	Contains the name of the ExclusionGroup property of data flow components.
	s_STOCKPROPNAME_HASSIDEEFFECTS	Contains the name of the HasSideEffects property of data flow components.
	s_STOCKPROPNAME_ISDISTRIBUTABLE	Contains the name of the IsDistributable property of data flow components.
	s_STOCKPROPNAME_ISERROROUT	Contains the name of the IsErrorOut property of data flow components.
	s_STOCKPROPNAME_ISSORTED	Contains the name of the IsSorted property of data flow components.
	s_STOCKPROPNAME_REFMETADATAID	Contains the name of the ReferenceMetaDataID property of data flow components.
	s_STOCKPROPNAME_SORTKEYPOS	Contains the name of the SortKeyPosition property of data flow components.
	s_STOCKPROPNAME_SYNCINPUTID	Contains the name of the SynchronousInputID property of data flow components.

上層

備註

Inherit from this class to create your own data flow component. This class implements the required component interfaces, IDTSDesigntimeComponent100 and IDTSRuntimeComponent100. You override the base class implementation of these methods to provide the functionality of your component. PipelineComponent provides helper methods in addition to the methods of the component interfaces to help you in developing your component.

範例

The following code example shows a component that implements the DtsPipelineComponentAttribute and inherits from the PipelineComponent class.

using System;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
namespace Microsoft.Samples.SqlServer.Dts
{
    [DtsPipelineComponent(DisplayName="SampleComponent")]
    public class SampleComponent : PipelineComponent
    {
        public override ProvideComponentProperties()
        {
            // TODO: Implement component intialization.
        }
        public override DTSValidationStatus Validate()
        {
            // TODO: Implement component validation.
        }
        public override void ProcessInput( int inputID, PipelineBuffer buffer)
        {
            // TODO: For transformation and destination components,
            //  implement code to process incoming rows.
        }
    }
}

Imports System 
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper 
Namespace Microsoft.Samples.SqlServer.Dts 

 <DtsPipelineComponent(DisplayName="SampleComponent")> _ 
 Public Class SampleComponent 
 Inherits PipelineComponent 

   Public Overrides Sub ProvideComponentProperties() 
    ' TODO: Implement component intialization.
   End Sub 

   Public Overrides Function Validate() As DTSValidationStatus 
    ' TODO: Implement component validation.
   End Function 

   Public Overrides Sub ProcessInput(ByVal inputID As Integer, ByVal buffer As PipelineBuffer) 
    ' TODO: For transformation and destination components,
    '  implement code to process incoming rows.
   End Sub 
 End Class 
End Namespace

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。

請參閱

參考

Microsoft.SqlServer.Dts.Pipeline 命名空間