Data Flow Destination

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

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

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


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


Use the parameters below to setup the component.


SignalEnd (1.2 SR-2)

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

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

        GetEventFinished_ = result
    End Function    ' GetEventFinished_