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)

    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.

      • 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 ...

      • 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 ...

      • Can I enable a property to be set dynamically from variable using an SSIS Expression?

        When using Data Flow Task Plus, sometimes you want to be able to set parameters in the source, transformation or destination components within the data flow, but those parameters are not available by default. Let's take a look at an example.  In this ...