SSIS Script Task appears to run, but actually doesn't
There are 3 things you can check:

(1) The TargetServerVersion property

Check that you are selecting the appropriate TargetServerVersion property

GoTo Project Properties &gt;&gt; Configuration Properties &gt;&gt; TargetServerVersion




(2) ForceExecutionResult property Value

Click on Fail Task and press F4 to show the perperty Tab, check that ForceExecutionResult is set to False.

(3) Run in 32-bit mode

Try running the package in 32-bit mode:

GoTo Project properties &gt;&gt; Debugging &gt;&gt; Run64BitRuntime  = False