Now we need to build the Address Lookup tables. To do this you will need to add a Task entry. In the tree, right click on the Build My Addresses from AddressBase Job you have just created and select New Task.

Select the Stored Procedure type and click OK.

Name

Enter a name for the task e.g. Build Address Lookups.

Connection Details

Select the iShare database from the list. Then select the Workflow radio button as this will limit the list of available Functions and then select the at_wkf_build_from_addresspremium_astype entry from the list.

Now click on the "type" parameter and enter Property in the Edit parameter area as in the above screenshot.

Run the Task to Build the Address Lookups

Now we need to run the task to build the Address Lookups to test that it works correctly.

Right click on the Task and select Run Build Address Lookups [or whatever you called the task]. Depending upon the size of your AddressBase database this may take a little while.

Browser not supported