Script it…then walk away!
The problem: Create a SSIS package that will update a table with only new records
The quick and dirty solution:…
1. Drop a Data Flow Task
2. Inside 1, Drop (in this order) an OLE DB Source, Lookup, and SQL Server Destination
3. The OLE DB Source is your select statement from data source, for example mine is:
SELECT data1, data2, data3, etc, from sourceTable
4. The lookup contains a query to compare, for example mine is:
SELECT data1, data2, data3, etc, from destinationTable
5. Configure the Error Output on the Lookup to Redirect Row
6. Connect the Red Arrow from the Lookup to your SQL Server Destination