共用方式為


DtsPipelineComponentAttribute.ComponentType 屬性

Identifies a component as a source, destination, or transformation.

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

語法

'宣告
Public Property ComponentType As ComponentType 
    Get 
    Set
'用途
Dim instance As DtsPipelineComponentAttribute 
Dim value As ComponentType 

value = instance.ComponentType

instance.ComponentType = value
public ComponentType ComponentType { get; set; }
public:
property ComponentType ComponentType {
    ComponentType get ();
    void set (ComponentType value);
}
member ComponentType : ComponentType with get, set
function get ComponentType () : ComponentType 
function set ComponentType (value : ComponentType)

屬性值

型別:Microsoft.SqlServer.Dts.Pipeline.ComponentType
A value from the ComponentType enumeration.

備註

This optional property identifies the component as a source, transformation, or destination component. SSIS Designer uses this attribute to group components in the Data Flow Items Toolbox from top to bottom with source components first, then transformation components, and finally destination components.

[!附註]

When you add a new component to the Data Flow Items toolbox, it appears at the bottom of the list of available components. To re-group components by ComponentType right-click the toolbox, click Reset, and then close and reopen SQL Server Data Tools (SSDT).

請參閱

參考

DtsPipelineComponentAttribute 類別

Microsoft.SqlServer.Dts.Pipeline 命名空間