Data Flow Source


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

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

Looking for older releases? Check here.

Overview

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.

Setup

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

Parameters

PackageConnection

Specify the package connection.

DataFlowDestination

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

        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_