Data Flow Destination

Use this variable to contain the ManualResetEvent object, which signals that a waiting thread process is complete. Download a sample SSIS package or check the following script function showing 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_