Managed File Transfer User Guide

10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Using the SQL Wizard

There are two methods to access the SQL Wizard from within

Managed File Transfer

If you want to build a SQL statement without embedding it into a Project, click the

System > Tools > SQL Wizard

link from the main menu bar. You will first be prompted to choose a Database Resource from a list, and then click the

Connect

button. After the connection is established, you can use the tabs to build the parameters of the SQL statement.

Otherwise, if you want to build a SQL statement to embed within a Project, then click the

button next to SQL Statement field on the SQL task's query element from within the Project. You will first be prompted to choose a Database Resource from a list, and then click the

Connect

button. After the connection is established, you can use the tabs to build the parameters of the SQL statement. Finally, click the

Select

button to apply the SQL Statement to the query.

The SQL Wizard page (shown below) is made up of several panels where the schemas, tables, columns, etc. can be selected. You can navigate to a panel by clicking its corresponding tab.

Follow the steps below to use the SQL Wizard.

Tools

Step 1: Choose the Schemas or Libraries

Step 2: Choose the Tables (Physical Files)

Step 3: Choose the Columns (Fields)

Step 4: Choose the Column Headings

Step 5: Specify the Where criteria

Step 6: Specify the Join criteria

Step 7: Specify the Order By criteria

Step 8: Additional tailoring of the SQL statement

Step 9: Test and Generate the SQL statement

Download Guide