I am working on Project where I want to create a template SSIS Package. What I would like, when SSIS Package fails. Email the user
with Row Number/Row Numbers or Column/Columns are having a problem. Either Package fail in any Transformation/source or in the destination.
For e.g my simple package is
- Flat File Source
- Data Conversion Task
- Derived Column Task
- OLE Db Destination.
Please guide me how can I accomplish this task.