<div>
<div class="content wysiwyg-content">
I download an XML file from the internet every 30 minutes, this XML file is then split up into 5 different tables. This all works fine, however I have now created 5 new tables mirroring the other 5 with _U appended to the name. What I want to do is every time I do this download, I want to wipe the original tables, load the data in and then only move the records that don't exist in the 5 tables with _U into them, so I only want any data duplication in the _U tables.<br />
<br />
What is the easiest way to do this with a bit of an example please.
</div>
</div>


I download an XML file from the internet every 30 minutes, this XML file is then split up into 5 different tables. This all works fine, however I have now created 5 new tables mirroring the other 5 with _U appended to the name. What I want to do is every time I do this download, I want to wipe the original tables, load the data in and then only move the records that don't exist in the 5 tables with _U into them, so I only want any data duplication in the _U tables.

What is the easiest way to do this with a bit of an example please.

SSIS and duplicate rows

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.