[[i2b2 - UHL clinical informatics system integration PATS|Back]] Version 2 of the i2b2 PATS data integration load will also use SSIS, but will address the following issues with version 1. 1. Address and document the correct procedure for dealing with duplicates and missing data, by getting Claire Hutton to define which items are true duplicates and may be discarded and identifying a means of distinguish between duplicates where both should be loaded into i2b2. 1. Improve the error handling and reporting. 1. Move the SSIS packages onto the BRICCS SQL Server so that we can control their running and updating. 1. Be configurable so that the source and destination databases can be changed more easily.