Andy Brownsword does a bit of logging:
When creating SQL Agent jobs to execute SSIS packages we can choose the level of logging to be captured. Different settings are more beneficial under the right circumstances so it’s important to understand the differences to make the right decision.
These settings control the internal logging done by SSIS. This is out of the box and freely available, so why not use it effectively.
The real trick is that if you swallow all of the exceptions and errors, everybody will just assume your code is working perfectly and boom, problem solved. Or you could read Andy’s post and get actual information. Whatever works for you, I suppose.
Leave a Comment