[b]Failure precedence is not triggered. Why? [/b]

[mjjks]

Hello,

I have a SQL task where I drop primary key and index on table:

IF EXISTS (Select * from INFORMATION_SCHEMA.TABLES Where TABLE_NAME = 'cpr_charm_file_current')
ALTER TABLE [RC].chrateimportadmin.CPR_CHARM_FILE_CURRENT
DROP CONSTRAINT PK_CPR_CHARM_FILE_CURRENT

DROP INDEX cpr_charm_file_current.idx_initial_low

On failure workflow precedence, it should jump to another SQL task to log an error into table but that never happens. Step errors out and execution stops.

Any ideas why?

Thanks

mjjks

 

[andrea96]

In the package properties, Logging tab, do you have "Fail package on first error" checked?