forum.venkateswarlu.net
      Register      Login
How To Capture Validation Errors Inside SSIS Package

1 replies to this topic

Cherukuri Venkateswarlu #1
Member
140 Points
 Posted on 25 Nov 2013 10:18 AM IST
SSIS Package: Exporting data from Excel to Database Table

I want to always send an e-mail when an error occurs in my SSIS package. For that I added an e-mail task in Event Handlers tab. It is executing fine if any task failed while executing the SSIS Package.

To test this I deleted my Excel template. Then I am getting a Package Validation Error when trying to execute the package and it didnt send e-mail. So when there is a Packaga Validation Error, package is not executing, so it is not sending email.
 
SSIS     987 views     Reply to this topic
Cherukuri Venkateswarlu #2
Member
140 Points
 Replied on 25 Nov 2013 10:19 AM IST To fix this issue set DelayValidation=TRUE on the object that is failing validation. This should result in it getting executed - and failing. 
Reply to this topic