IDTSPath100.AttachPathAndPropagateNotifications 메서드

  • 참조

정의

네임스페이스:
Microsoft.SqlServer.Dts.Pipeline.Wrapper
어셈블리:
Microsoft.SqlServer.DTSPipelineWrap.dll

두 구성 요소 사이의 경로를 설정하고 영향을 받는 구성 요소에 알립니다.

public:
 void AttachPathAndPropagateNotifications(Microsoft::SqlServer::Dts::Pipeline::Wrapper::IDTSOutput100 ^ pIDTSOutput, Microsoft::SqlServer::Dts::Pipeline::Wrapper::IDTSInput100 ^ pIDTSInput);
[System.Runtime.InteropServices.DispId(104)]
public void AttachPathAndPropagateNotifications (Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSOutput100 pIDTSOutput, Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSInput100 pIDTSInput);
[<System.Runtime.InteropServices.DispId(104)>]
abstract member AttachPathAndPropagateNotifications : Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSOutput100 * Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSInput100 -> unit
Public Sub AttachPathAndPropagateNotifications (pIDTSOutput As IDTSOutput100, pIDTSInput As IDTSInput100)

매개 변수

pIDTSOutput
IDTSOutput100

업스트림 구성 요소의 출력입니다.

pIDTSInput
IDTSInput100

다운스트림 구성 요소의 입력입니다.

특성
DispIdAttribute

예제

다음 코드 예제에서는 새 경로를 만들고 두 구성 요소 간에 경로를 설정하는 방법을 보여 줍니다.

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.  
        IDTSComponentMetaData100 md = AddComponentToDataFlow( m , "DTSAdapter.OLEDBSource");  
        IDTSComponentMetaData100 oledbSrc = m.ComponentMetaDataCollection.New();  
        CManagedComponentWrapper100 srcWrp = oledbSrc.Instantiate();  
        srcWrp.ProvideComponentProperties();  

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

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

}  
public IDTSComponentMetaData100 AddComponentToDataFlow( MainPipe mp , string Component )  
{  
    if( mp != null )  
    {  
        IDTSComponentMetaData100 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 IDTSComponentMetaData100 = AddComponentToDataFlow(m, "DTSAdapter.OLEDBSource")   
 Dim oledbSrc As IDTSComponentMetaData100 = m.ComponentMetaDataCollection.New   
 Dim srcWrp As CManagedComponentWrapper100 = oledbSrc.Instantiate   
 srcWrp.ProvideComponentProperties   
 Dim oledbDest As IDTSComponentMetaData100 = AddComponentToDataFlow(m, "DTSAdapter.OLEDBDestination")   
 Dim destWrp As IDTSComponentMetaData100 = oledbDest.ComponentMetaDataCollection.New   
 Dim destWrp As CManagedComponentWrapper100 = md.Instantiate   
 destWrp.ProvideComponentProperties   
 Dim path As IDTSPath100 = 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 IDTSComponentMetaData100   
 If Not (mp Is Nothing) Then   
   Dim md As IDTSComponentMetaData100 = 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

설명

이 메서드는 입력과 입력 간의 IDTSOutput100 데이터 흐름을 설정하는 것 외에도 구성 요소의 메서드 및 OnOutputPathAttached 호출 OnInputPathAttached 을 통해 이벤트의 각 구성 요소를 알 수 IDTSInput100 있습니다.

적용 대상