Package status = Succeeded despite errors

Question

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Pete Bishop Default port Points: 1493 More actions · Answer 1

Grrr... Such a simple answer! For some reason I'd set it to 0.

Many thanks.

Phil Parkin SSC Guru Points: 247183 More actions · Answer 2

I would have expected it to report a failure in that case, but to be brutal you could add a Script Task to your OnError handler which does this:

public void Main()
        {
            //Fail the package
            Dts.TaskResult = (int)ScriptResults.Failure;
        }