When executing a sql task, how do you get the failure constraint to be
tripped? I want an email to be sent when a sql script is not
successfully executed, but the package just seems to end and never
executes the send mail task. I've tried using RAISERROR() but that
doesn't seem to work either. When the task successfully executes the
success constraint works perfectly fine. Thanks for any help.

Just to be clear this is using SSIS in SQL Server 2005.

Hello Matt,

It works for me. For the SQL Statement I entered RAISERROR('This is an Error',16,1).

Is this package Vanilla?


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi Allan,
Thanks for the response. As an experiment I ended up recreating it with
a new SQL task and now it seems to work. I also had a data flow task
that wasn't properly tripping the error constraint either and after I
recreated it, that seems to work properly now too. The only thing I can
think of is that I used the import/export wizard to originally create
the package then modified it from there rather than originally creating
it within VS.NET. Other than that, I have no idea what the problem was
as I cut and pasted everything exactly as it was before.