Data Flow Source

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.

Parameters

Configuration

Use the parameters below to configure the component.

PackageConnection

Specify the package connection.

DataFlowDestination

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

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_

What's New

1.3 SR-4

Fixed: Component was not able to locate a Data Flow Destination, when the Data Flow Task was contained in For Each Loop container (Thank you, Miguel).

1.2

New: Introduced component.

Ready to give it a try?

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