How to FAIL package intentionally?

Hot Topic

Single XML file from multiple result sets - How do I do this ?
Last Cube Process Date/Time
import from Access to SQL, not knowing the table format
Sequel express uninstall problem
How to launch programatically a SSIS package?
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
SSIS Requests...
Problem using SQL Server Mobile 2005 with Windows Mobile 5 application
Strange problem with DataReaderSource
Error OutPut in Custom Source Component

SQL Server

Help! - Error in moving data from AS400
Dynamic building of reports in C# for ASP.NET
Problems with debugging remotely SQLCLR stored procedures?
SQL CE & @@IDENTITY
Copy data from one table to another
Upgrading to SQL 2005
Date Conversion throws truncation error
DTS - Import Text Files
classes Vs structs
Custom Report Item questions

How to FAIL package intentionally?

I need to fail the package intentionally if Send EMail task executes. How can I do that I know there is a property FailPackageOnfailure, that fails the package on task's failure, but how can I fail the package on task's successful execution

Thanks in advance



Answer this question

How to FAIL package intentionally?

  • RobDog888

    How about setting an expression on ForceExecutionResult Setting 1 is failure. This works for me on tasks, success vs failure constraints are followed, but the output window for the package still said success. Maybe the debug host doesn't pick this up, but your normal host would.

  • How to FAIL package intentionally?
Answer this question