Export (0) Print
Expand All

IDTSPath90 Interface

SQL Server 2005

Represents a connection between two components.

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

[TypeLibTypeAttribute(4160)] 
[GuidAttribute("CBEA73B4-08DA-4FE7-A03A-829345CAEB84")] 
public interface IDTSPath90 : IDTSObject90
/** @attribute TypeLibTypeAttribute(4160) */ 
/** @attribute GuidAttribute("CBEA73B4-08DA-4FE7-A03A-829345CAEB84") */ 
public interface IDTSPath90 extends IDTSObject90
TypeLibTypeAttribute(4160) 
GuidAttribute("CBEA73B4-08DA-4FE7-A03A-829345CAEB84") 
public interface IDTSPath90 extends IDTSObject90

Path objects are created to establish the flow of data between the IDTSOutput90 of an upstream component and the IDTSInput90 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 IDTSComponentMetaData90 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 IDTSPath90 object, and then attach the output of the upstream component to the input of the downstream component.

public IDTSPath90 EstablishPath( MainPipe mp , IDTSOutput90 start , IDTSInput90 end )
{
IDTSPath90 path = mp.PathCollection.New();
path.AttachPathAndPropagateNotifications( start, end );
return path;
}

Public Function EstablishPath(ByVal mp As MainPipe, ByVal start As IDTSOutput90, ByVal end As IDTSInput90) As IDTSPath90 
 Dim path As IDTSPath90 = mp.PathCollection.New 
 path.AttachPathAndPropagateNotifications(start, end) 
 Return path 
End Function

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft