Submitted by @stodoroska from Interworks
This pipeline reads the data from Excel spreadsheet, deletes all the records from the corresponding SQL Server lookup table, and after that re-populates the same SQL Server lookup table with the data that was previously read.
Join Snap is waiting for all the records from the database table to be deleted, then the database table is re-populated
Sources: Excel file on a File share system
Targets: SQL Server database table
Snaps used: File Reader, Excel Parser, Copy, Filter, SQL Server - Delete, Mapper, Join, SQL Server Execute
Re-populate.SQLServer.LookupTable.slp (10.5 KB)