How to build the data flow setup

How to build the data flow setup

The initialization and user interface for a data flow is defined by implementing properties on the script EntryPoint class. The documentation and samples of Script Task Plus for defining parameters is relevant to the Data Flow Task Plus initialization setup, so we will not repeat it here. Here you will find a description of the DataFlowSetting .NET attribute, used to apply values to specific data flow component parameters.

  • Go to the Toolbox and open the Choose Toolbox Items ... dialog. Press the SSIS Control Flow Items tab and select Data Flow Task Plus. Add Reference
  • Drag Data Flow Task Plus into your control flow package and open the Design Script IDE.
  • Add a reference in the script project to CozyRoc.SSISPlus Add Reference
  • Include Imports CozyRoc.SqlServer.SSIS.Attributes in the script. It is also recommended that you include Imports System.Drawing.
?
1
2
3
4
Imports System.Drawing
Imports CozyRoc.SqlServer.SSIS.Attributes
 
Public Class ScriptMain
  • Now you are ready to define your first Data Flow Task Plus Parameter.