Task Factory Data Flow Nugget Transform

Data Flow Nugget Transform

Transform IconTransform Description
Task Factory Data Flow Nugget Transform IconThe Data Flow Nugget Transform allows you to configure a reusable data flow transform package.

Requirements

Nugget Package Requirements

Your data flow nugget package must meet the following requirements to make it available for reuse in the Data Flow Nugget Transform:

  • Must have a data flow task - The Data Flow Nugget Transform reads a package looking for data flow tasks during setup. You must choose a package that contains a data flow task that follows the next two rules.
  • Must have a placeholder source - The placeholder source is used to define the input columns for the data flow nugget.
  • Must have a terminator destination - The terminator destination is used to define the columns that are returned from the data flow nugget package. Select the checkbox in the include column for the Data Flow Nugget Transform to detect that is an output column.

Task Factory Terminator Destination Input Columns

Setup

Setting Up a Data Flow Nugget

  1. After you have setup a package to be used that meets the three requirements, choose the package in the transform editor's window. The child package can be located either on a file system, SQL server, or an SSIS Catalog. Note:  If you choose SQL Server or SSIS Catalog, you must select a connection manager that connects to the server where the package is stored.
    Task Factory Data Flow Nugget Transform Choose Package
  2. Next you map the input columns. Any of the columns that are defined in the placeholder source need to be mapped in the Input Columns step. The Nugget Column displays a drop down that contains all of the columns defined in the placeholder source. Note:  If any columns defined in the placeholder source are not mapped in the Data Flow Nugget Transform you receive an error telling you to map the columns.
    Task Factory Data Flow Nugget Transform Input Columns
  3. Output columns shows the columns defined in the Terminator Destination component of your data flow nugget package. What displays depends on whether you have an asynchronous component in your nugget package. With an asynchronous component, you see all of the columns marked as Include in the terminator destination in the Output Columns from Nugget grid.
  4. On the Variables page, you are able to map the values of variables from the package that contains the Data Flow Nugget Transform to the variables that exist in the child nugget package.
  5. The last step is to map the connection managers from the package that contains the Data Flow Nugget Transform to the connection managers that exist in the child nugget package.
Execution

Executing Data Flow Nugget Transforms

To execute a package that contains a Data Flow Nugget you need to use the Advanced Execute Package Task. The following shows the correlation between the three packages that are needed to execute Data Flow Nuggets.

Package 1 - The Nugget Package

The nugget package is the reusable package that contains any of the reusable logic that executes within a Data Flow Nugget Transform.

Task Factory Nugget Package

Package 2 - The Data Flow Nugget Transform Package

This package contains the Data Flow Nugget Transform that references Package 1.

Task Factory Data Flow Nugget Transform Package

Package 3 - The Advanced Execute Package Task Package

This package contains an Advanced Execute Package Task that references Package 2 as it's Child Package.

Task Factory Advanced Execute Package Task Package