How to stop data flow SSIS when there is a lookup match output and carry on when No Match Output
I have a SSIS package that imports data from spreadsheet into temp table by checking if the data ( year column ) doesn't exist in destination table then will insert data into table. I would like the package to stop if it finds a matching year in destination table.
what the data flow looks like
Excel Source --> Data Conversion --> Lookup --> OLE DB Destination