How can I dynamically modify a transformation in a Data Flow Task?

How can I dynamically modify a transformation in an SSIS Data Flow Task?

COZYROC's Data Flow Task Plus allows you to dynamically modify source, destination and transformation components at runtime.

For an overview and listing of properties for the following transformations, please check out the side menu item "Parameters" here: 

Transformations:
Aggregate Transformation
Character Map Transformation
Conditional Split Transformation
Copy Column Transformation
Data Conversion Transformation
Derived Column Transformation
Export Column Transformation
Fuzzy Grouping Transformation
Fuzzy Lookup Transformation
Import Column Transformation
Lookup Transformation
Lookup Plus Transformation
OLE DB Command Transformation
Pivot Transformation
Sort Transformation
Table Difference Transformation
Template Transformation
Term Extraction Transformation
Term Lookup Transformation
Unpivot Transformation

Also, you will find the following sample package entitled "Sample package demonstrating all dynamic data flow transformations" from the "Samples" menu item on the side menu located here: 

This package demonstrates the following transformations using Dynamic Data Flow in Data Flow Task Plus
Transformations:
Aggregate Transformation
Character Map Transformation
Conditional Split Transformation
Copy Column Transformation
Data Conversion Transformation
Derived Column Transformation
Export Column Transformation
Fuzzy Grouping Transformation
Fuzzy Lookup Transformation
Import Column Transformation
Lookup Transformation
Lookup Plus Transformation
Merge
Merge Join
Union All
OLE DB Command Transformation
Pivot Transformation
Row Sample
Table Difference Transformation
Term Extraction Transformation
Term Lookup Transformation
Unpivot Transformation

For demonstration videos showing examples of using Derived Column Transformation dynamically in COZYROC's Data Flow Task Plus, check out the following two video titles located here:

Dynamic Derived Column Transformation in conjunction with Data Flow Task Plus (1 of 2)
Dynamic Derived Column Transformation in conjunction with Data Flow Task Plus (2 of 2)

    • Related Articles

    • 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 ...
    • Match multiple columns with Lookup Plus

      You can match multiple columns using the Lookup Plus component. See the steps below for one possible solution: Create a new data flow. This data flow will build a lookup reference dictionary and store it in a package variable. Insert a data flow ...
    • 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 ...
    • 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 ...
    • 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 ...