Export (0) Print
Expand All

IDTSPath100 Interface

Represents a connection between two components.

Namespace:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly:  Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)

[TypeLibTypeAttribute(TypeLibTypeFlags::FDual|TypeLibTypeFlags::FDispatchable)]
[GuidAttribute(L"7BD99105-F435-4265-83DA-BC0023CC293C")]
public interface class IDTSPath100 : IDTSObject100

The IDTSPath100 type exposes the following members.

  NameDescription
Public propertyDescriptionGets or sets the description of the IDTSPath100 object.
Public propertyEndPointGets or sets the IDTSInput100 object associated with a path.
Public propertyIDGets or sets the ID of an IDTSPath100 object.
Public propertyIdentificationStringGets a unique string that identifies an IDTSPath100 object.
Public propertyNameGets or sets the string identifier of an IDTSPath100 object.
Public propertyObjectTypeReturns a value from the DTSObjectType enumeration.
Public propertyStartPointGets or sets the IDTSOutput100 object associated with a path.
Public propertyVisualizedSets a value indicating that the user has attached a data viewer to this path in SSIS Designer.
Top

  NameDescription
Public methodAttachPathAndPropagateNotificationsEstablishes a path between two components and notifies the affected components.
Top

Path objects are created to establish the flow of data between the IDTSOutput100 of an upstream component and the IDTSInput100 of another component. A path contains a single output object represented as the StartPoint, and a single input, which is the EndPoint of the path. A path between two components is established in a two-step process. First, create the path by calling New on the path collection of the IDTSComponentMetaData100 object. Second, establish the path by calling AttachPathAndPropagateNotifications on the path itself. This method establishes the path and notifies the affected components of its existence.

The columns of the StartPoint are subsequently mapped to the EndPoint by calling SetUsageType.

The following code example demonstrates how to create a new IDTSPath100 object, and then attach the output of the upstream component to the input of the downstream component.

No code example is currently available or this language may not be supported.

Community Additions

ADD
Show:
© 2014 Microsoft