Explore LABS


S2.2.4 - SSIS Tutorial - Addressing - understanding the outputs

Previous Article Next Article 

1) By default – you should see something like this your first time setting up a task if you have a standard input

Whether it passes or fails validation, we still write out the address to the result table, this way you can go straight to matching right after without having to run update queries back to your table.


That’s also why we add the _corrected suffix to all the column names, that way you can join it back to your source table and not have to worry about ambiguous column names.

2)Do I really need all these?  Most clients will will have 4 - 5 address lines in their source data, however some addresses on the PAF file contain more than this, for this reason we suggest you allow the software to add the Town and County in addition to your source fields because this allows the extra room for addresses that return more than the original 4 address lines in the example data shown above (notice the lack of source field definitions for Town_corrected an Country_corrected).  But we would recommend running proper QA before committing any changes back to your source data



3) What if I want to concatenate multiple columns? if you have a requirement to stick to a certain number of address lines or simply want multiple address elements to be concatenated into particular fields, you can use this feature to achieve, then this is how you would do it.


Select the Show advanced options checkbox in the bottom left corner of this screen:


Output2 will show up, and you’ll see you can choose to add additional address elements into a single address field. When you select an address element in Output2, then Output 3 will show up allowing you to  add further address elements. This will concatenate them in your output address field using commas to separate the elements.


You’ll also notice when you click advanced options that there are some hidden columns that show up. Pafflag and PafDesc for example can help you to understand the results – such as being able to tell which addresses have been validated and what changes were made, or to identify possible errors with the information. We’ll get more into the results next.


What about that filtering tab?

You can use this if you only want to work on a subset of data or to avoid processing records, such as only records which null values in the postcode field (note that this is a null value and not just a blank field in this example)


The Advanced tab:

The advanced tab allows you to set some of the more granular settings in addressing such as the number of threads to use, whether to capitalise post towns etc.

Process type allows you to specify whether to use namesCorrection or AddressCorrection. Address correction is the default, if you want to use name correction you will require the additional names dataset, please contact our sales department if you are interested in purchasing this.

There are many more setting here but if you highlight the setting, a tool tip for that setting will be displayed at the bottom of this screen describing the settings function.



Previous Article matchIT SQL Index Next Article
Was this article helpful?
0 out of 0 found this helpful


Please sign in to leave a comment.