I need to create a package that imports data from an Excel file into a MSSQL database. The package needs to lookup codes from the database using descriptions in the Excel file, if the lookup does not match then I would like to email an end user about the non-matching lookup and stop the database import.
So far I have added a lookup and set it to redirect error rows, which works fine. But I am unable to stop the database import.
Is this possible?