Excel to SQL Server after Clearing the Lookup Table

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.

Configuration

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