When you first create a task, the Database/template tab is the only tab available.

Initially, you use it to:

• Maintain the connection to the data's destination
  
  
• Select the Task Method Template, which in turn defines the type of SQL statement used to interact with the destination

The first panel, Data destination, contains the connection string used to access the data destination. The Connection icon indicates the current status of the connection, as follows:

• red – not connected
• orange – the connection string has been modified since connection was made
• green – currently connected

With some tasks you may want the user to supply one or more parts of the connection string, for example, they may have to enter a password. To do this, you first specify a task parameter and then include it in the connection string. The user will be prompted for the value of the parameter whenever they run the task.

Once the connection and task action have been defined, you can go on to specify the remainder of the task using the other tabs.

Select the Task Method Template