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.