다음을 통해 공유


IDTSPath90.AttachPathAndPropagateNotifications Method

Establishes a path between two components and notifies the affected components.

네임스페이스: Microsoft.SqlServer.Dts.Pipeline.Wrapper
어셈블리: Microsoft.SqlServer.DTSPipelineWrap (in microsoft.sqlserver.dtspipelinewrap.dll)

구문

‘선언
<DispIdAttribute(104)> _
Sub AttachPathAndPropagateNotifications ( _
    <InAttribute> pIDTSOutput As IDTSOutput90, _
    <InAttribute> pIDTSInput As IDTSInput90 _
)
[DispIdAttribute(104)] 
void AttachPathAndPropagateNotifications (
    [InAttribute] IDTSOutput90 pIDTSOutput,
    [InAttribute] IDTSInput90 pIDTSInput
)
[DispIdAttribute(104)] 
void AttachPathAndPropagateNotifications (
    [InAttribute] IDTSOutput90^ pIDTSOutput, 
    [InAttribute] IDTSInput90^ pIDTSInput
)
/** @attribute DispIdAttribute(104) */ 
void AttachPathAndPropagateNotifications (
    /** @attribute InAttribute() */ IDTSOutput90 pIDTSOutput, 
    /** @attribute InAttribute() */ IDTSInput90 pIDTSInput
)
DispIdAttribute(104) 
function AttachPathAndPropagateNotifications (
    pIDTSOutput : IDTSOutput90, 
    pIDTSInput : IDTSInput90
)

매개 변수

  • pIDTSOutput
    The output of the upstream component.
  • pIDTSInput
    The input of the downstream component.

주의

In addition to establishing the flow of data between an IDTSOutput90 and an IDTSInput90 input, this method also notifies each component of the event by calling the OnInputPathAttached and OnOutputPathAttached methods of the component.

The following code example demonstrates how to create a new path and establish the path between two components.

using System;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
using Microsoft.SqlServer.Dts.Runtime;

...

    public static void main( string []args )
    {
        // Create the package and add a data flow task.
        Package p = new Package();
        TaskHost th = p.Executables.Add("DTS.Pipeline",null) as TaskHost;
        MainPipe m = th.InnerObject as MainPipe;

        // Create an OLE DB source component.
        IDTSComponentMetaData90 md = AddComponentToDataFlow( m , "DTSAdapter.OLEDBSource");
        IDTSComponentMetaData90 oledbSrc = m.ComponentMetaDataCollection.New();
        CManagedComponentWrapper90 srcWrp = oledbSrc.Instantiate();
        srcWrp.ProvideComponentProperties();

        // Create an OLE DB destination component.
        IDTSComponentMetaData90 oledbDest = AddComponentToDataFlow( m , "DTSAdapter.OLEDBDestination");
        IDTSComponentMetaData90 destWrp = oledbDest.ComponentMetaDataCollection.New();
        CManagedComponentWrapper90 destWrp = md.Instantiate();
        destWrp.ProvideComponentProperties();

        // Establish the path.
        IDTSPath90 path = m.PathCollection.New();
        path. AttachPathAndPropagateNotifications( oledbSrc.OutputCollection[0], oledbDest.InputCollection[0]);

}
public IDTSComponentMetaData90 AddComponentToDataFlow( MainPipe mp , string Component )
{
    if( mp != null )
    {
        IDTSComponentMetaData90 md = mp.ComponentMetaDataCollection.New();
        md.ComponentClassID = Component;
        CManagedComponentWrapper wrp = md.Instantiate();
        wrp.ProvideComponentProperties();

        return md;
    }
    throw new Exception( "DataFlow task does not exist.");
}
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper 
Imports Microsoft.SqlServer.Dts.Runtime

...

Public Shared Sub main(ByVal args As String()) 
 Dim p As Package = New Package 
 Dim th As TaskHost = CType(ConversionHelpers.AsWorkaround(p.Executables.Add("DTS.Pipeline", Nothing), GetType(TaskHost)), TaskHost) 
 Dim m As MainPipe = CType(ConversionHelpers.AsWorkaround(th.InnerObject, GetType(MainPipe)), MainPipe) 
 Dim md As IDTSComponentMetaData90 = AddComponentToDataFlow(m, "DTSAdapter.OLEDBSource") 
 Dim oledbSrc As IDTSComponentMetaData90 = m.ComponentMetaDataCollection.New 
 Dim srcWrp As CManagedComponentWrapper90 = oledbSrc.Instantiate 
 srcWrp.ProvideComponentProperties 
 Dim oledbDest As IDTSComponentMetaData90 = AddComponentToDataFlow(m, "DTSAdapter.OLEDBDestination") 
 Dim destWrp As IDTSComponentMetaData90 = oledbDest.ComponentMetaDataCollection.New 
 Dim destWrp As CManagedComponentWrapper90 = md.Instantiate 
 destWrp.ProvideComponentProperties 
 Dim path As IDTSPath90 = m.PathCollection.New 
 path.AttachPathAndPropagateNotifications(oledbSrc.OutputCollection(0), oledbDest.InputCollection(0)) 
End Sub 

Public Function AddComponentToDataFlow(ByVal mp As MainPipe, ByVal Component As String) As IDTSComponentMetaData90 
 If Not (mp Is Nothing) Then 
   Dim md As IDTSComponentMetaData90 = mp.ComponentMetaDataCollection.New 
   md.ComponentClassID = Component 
   Dim wrp As CManagedComponentWrapper = md.Instantiate 
   wrp.ProvideComponentProperties 
   Return md 
 End If 
 Throw New Exception("DataFlow task does not exist.") 
End Function

스레드 보안

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

IDTSPath90 Interface
IDTSPath90 Members
Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace