Architecture selection

Let us consider the components that make up this candidate architecture.

SQL Server, Master Data Services, and SSIS
Benefits Easily deployed and extensible ETL tool Designed to handle batch processing of large files, exactly the task at hand No additional licensing costs comes with SQL Server Can be built and maintained by current staff Can build business rules to resolve data conflicts	Risks Need to build sophisticated error handling systems Does not handle unstructured data well
Search Server
Benefits Indexes unstructured data Can review administrative shares (such as C$) on desktops	Risks Not clear if staff has the skills to support product Still possible for users to "hide" relevant documents on portable devices

This is an extraordinarily complex data management task as it touches on all of the data held by the organization in every possible format in which the organization holds it. You must get data in both the organizations "approved...