SQLTeam.com | Weblogs | Forums

Configure Error Out Email in SSIS "Help"


#1

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

  1. Flat File Source
  2. Data Conversion Task
  3. Derived Column Task
  4. OLE Db Destination.

Please guide me how can I accomplish this task.