Data Flow Destination

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.

Parameters

Configuration

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(&quot;Invalid variable type&quot;)
End If
Finally
If Not vars Is Nothing Then
Call vars.Unlock()
End If
End Try
GetEventFinished_ = result
End Function ' GetEventFinished_

What's New

1.2

New: Introduced component.

Ready to give it a try?

COZYROC SSIS+ Components Suite is free for testing in your development environment.