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.

    • Related Articles

    • Dynamic Data Flow - Dynamic Column Custom Handler

      To setup custom routine in the data flow script for additional setup of dynamically added data flow column, attribute your script main class with DataFlowColumnAdded attribute. Set as parameter the name of the script method. Check below the required ...
    • Dynamic Data Flow - How to create completely dynamic data flow?

      Starting from 1.4 SR-3 the data flow can be completely dynamic - the need to have one common column across different iteration sets is no longer required. To have completely dynamic components, you have to remove all statically defined columns (both ...
    • Data Flow Task Plus editor doesn't open

      When I double-click on Data Flow Task Plus,  the Data Flow Task Plus Editor doesn't open and instead of that I am sent to the Data Flow tab. There is a known issue in Visual Studio when a solution file is opened externally (e.g. from the taskbar ...
    • DataFlowSetting .NET attribute used with Data Flow Task Plus

      The DataFlowSetting .NET attribute defines a list of references to different component properties in the SSIS data flow. It defines the link between the initialization parameter and a specific SSIS data flow component parameter. You can apply one ...
    • Where can I find the documentation for the Data Flow Task Plus?

      You can find documentation related to all the COZYROC SSIS+ Suite tasks from the main products page. Specific documentation for the Data Flow Task Plus can be found at the following link.  For many of the tasks and components, you can find an ...