Since the error is trapped, then:

Dts.TaskResult = Dts.Results.Failure

Ooops, I meant:

Optimise it yourself:

and not

Optimise it yourself.

or

Optimise it yourself!

One dot makes a big difference sometimes.

Optimise it yourself.

Try capitalising all of the SQL Keywords, using proper join syntax, using better aliases and some indentation whileyou are at it.

I got it right because the last three answers have capitalized words and the first one does not.

@luke. Thanks for your reply and confirmation.

Unfortunatley it does not work correctly when I define the parameter as a string. It appears that it is accepted...