Data Flow Destination

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

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

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

Overview

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.


Setup

Use the parameters below to setup the component.

Parameters

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

        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_