This topic has not yet been rated - Rate this topic

DtsPipelineComponentAttribute.ComponentType Property

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

Namespace:  Microsoft.SqlServer.Dts.Pipeline
Assembly:  Microsoft.SqlServer.PipelineHost (in Microsoft.SqlServer.PipelineHost.dll)
public ComponentType ComponentType { get; set; }

Property Value

Type: 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.

Note Note

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).

Did you find this helpful?
(1500 characters remaining)