Posts Tagged ‘trapping’


Whenever we develop data maintenance packages through SSIS for our customers, one of the areas we pay particular attention to are invalid records. Where possible, we work with the owner of the data to put in code to cleanse the data as it is processed, but for unexpected errors, we like to create customer logging and error trapping, which processes the valid data, logs the invalid data (for manual entry or correction), and continues without failing the who