Data Flow Source

Specify the package connection.

Type the data flow destination, or click the browse button (...) to locate and select it.

Use this variable to contain the thread synchronization event object. If specified, the component will wait for a signal before starting to process data. Check the following script for an example showing how to handle this variable:

    ' Signals wait start variable. If not initialized yet, initialize to ManualResetEvent.
    Private Sub SignalStart_()
        Dim vars As Variables
        Dim eventSignal As EventWaitHandle

        Try
            Call Dts.VariableDispenser.LockOneForWrite(WaitStart, vars)
            If vars(WaitStart).DataType = TypeCode.Object Then
                eventSignal = TryCast(vars(WaitStart).Value, EventWaitHandle)
                If eventSignal Is Nothing Then
                    ' Signal variable is not yet initialized.
                    eventSignal = New ManualResetEvent(True)
                    vars(SignalEnd).Value = eventSignal
                Else
                    ' Set signal.
                    Call eventSignal.Set()
                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
    End Sub    ' SignalStart_