Data Flow Destination

Overview

Data Flow Destination Component is SSIS Data Flow Component for exposing data from a data flow to Data Flow Source component. It is similar in concept to the standard Microsoft DataReader Destination Component and it is used as a source in Data Flow Source component. The configuration options are provided in the standard data flow destination component dialog.

Setup

Use the options below to setup the component.

Options

SignalEnd (1.2 SR-2)

Variable containing ManualResetEvent object, signaling a waiting thread processing is complete. Check following script function as a sample how to handle this variable:

    ' Returns signal end variable. If not initialized yet, initialize to ManualResetEvent.
    Private Function GetEventFinished_() As EventWaitHandle
        Dim result As EventWaitHandle
        Dim vars As Variables

        Try
            Call Dts.VariableDispenser.LockOneForWrite(SignalEnd, vars)
            If vars(SignalEnd).DataType = TypeCode.Object Then
                result = TryCast(vars(SignalEnd).Value, EventWaitHandle)
                If result Is Nothing Then
                    ' Signal variable is not yet initialized.
                    result = New ManualResetEvent(False)
                    vars(SignalEnd).Value = result
                End If
            Else
                Throw New ApplicationException("Invalid variable type")
            End If
        Finally
            If Not vars Is Nothing Then
                Call vars.Unlock()
            End If
        End Try

        GetEventFinished_ = result
    End Function    ' GetEventFinished_