Configuring a Custom SQL Transformation Task

Define a custom transformation script using the Task Group component.

1. Add the Task Group component to the design window, right-click the component on the design window, and select Add task to create a new transformation task. Alternatively, double-click an existing Task Group component or with a Task Group component selected in the design window, click the Tasks icon in the Properties window, and click the Create a new task icon.
2. Select Custom SQL as the task type. Enter a name and description for the task and click Create.
3. Create the SQL script to describe a transformation. You can:

   • Manually enter the script in the SQL Script text area of the editor.

   • Drag and drop the references and functions you want to add to your script from the left pane to the text area.

     • The Model tab lists all the tables, views and stored procedures that you can use.

     • The Reference tab lists all available IQ functions and project variables that you can add to the script.

4. (Optional) Import or Export the SQL script from or to a file.
   • To import the SQL script from a file, click the Import From File icon, select the file to import, and click Open.
   • To export the script to a file, click the Export to File icon, provide a file name, and click Save.
5. Save the script and run it by clicking the Execute a Script icon. Alternatively, select Execute from the Script menu.