Script it…then walk away…
After creating and deploying your SSIS package, you might want to schedule it.
Schedule a SSIS Package
Tag Archives: ssis
SSIS Package to Insert New Records
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