Table of Contents

How To Parameterize the execution of Data Flows

Under this link you will find video that shows how to Parameterize the execution of Data Flows. Here you will find Documentation.

Step by step

  1. Right-click the selected folder in the Solution Explorer to add a new item, create Data Flow than Data Flow Item:

pic

  1. Open a New Resource Set:

pic

  1. Than New Asembly Reference:

pic

  1. Drag and Drop the task:

pic

  1. Drag and drop the Action:

pic

  1. Set it up:

pic

  1. Go to parameters and add yours:

pic

  1. Add Data Flow Item to the Data Flow:

pic

  1. Run it:

pic

  1. You can also set the arguments for the specific instance of the Data Flow Item:

pic

  1. Write our argument:

pic

  1. And there it is:

pic