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.

34%20PM

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

Downloads

Re-populate.SQLServer.LookupTable.slp (10.5 KB)