Data Flow Source

SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016

SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016

All Downloads ----- Join VIP ----- Questions?


The Data Flow Source Component is an SSIS Data Flow Component for consuming data in a data flow from the Data Flow Destination component. The configuration parameters are provided in the standard data flow source component dialog.


Use the parameters below to connect to the Data Flow Destination component.



Specify the package connection.


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

WaitStart (1.2 SR-3)

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

            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
                    ' Set signal.
                    Call eventSignal.Set()
                End If
                Throw New ApplicationException("Invalid variable type")
            End If
            If Not vars Is Nothing Then
                Call vars.Unlock()
            End If
        End Try
    End Sub    ' SignalStart_