I just noticed this in one of the OP's earlier posts – maybe it's what triggered Steve

And I could use...

What is the text of the error message you receive when running this?

Thanks, But my original question is not about how to use the tabs from advanced step about  success quit, and fail continue etc. I know all those. It is...

It's time for you to do some work yourself, rather than relying on me to spoon-feed you with every single detail.

Thanks, I know the condition and the process, but how can I construct the sql to let it know if it is 0 then on success, if 1 failure....

On Success and On Failure are your conditions.

Sue?

No code required. It's in the Advanced properties for the step.

Total number of rows should be equal to number of rows in C.

Unless multiple occurrences of the same CreditCheckLevel are returned by the subquery, in which case there will be...

This is a bizarre piece of code – can you explain what it is intended to do, please?

Why would CustomerId ever be equal to CreditCheckLevel? Even if it is, why...

Would you know how to do that?

No I don't. Constraints and checks are there to prevent bad things happening. They do not change data.

Have you considered leaving the column as...

I had a go at simplifying your first piece of code. As I don't have the underlying table structures, I may have made some slight mistakes, but see whether you...

Neither defaults nor constraints will help here.

But an INSTEAD OF INSERT trigger could do the work. Have a look here for an example/walkthrough.

Incidentally, what is the datatype of the...

The SQL Agent job steps idea could be expanded to something like this

1. T-SQL searches for new rows. Fail the step (select 1/0, or similar) if no new rows found.
   ...

I tried Run in 64 bit runtime to False still same error.

What error is that, exactly?