Error not flowing down Error Precedent Constraint path

I have a dataflow task which keeps erroring, at which point the flow should go down the red path to my error handling SQL Task.

But it is failing to do so.

anyone know why?

What type of transform are you using? (note: task is for control flow not data flow) Have you set up your error output to redirect rows on error? How about for truncation?

etc...

|||

Adolf,

could you explain bettter what is your problem?

You have in eventhandler a SQL task to save the inesperated error, true?

the error is in this SQL Task?

Regards!

|||This is occuring at the Control Flow level.

The design:
A data flow task has two paths coming out of it: 1 green, 1 red.
The green path continues on to another DF task, the red goes to an SQL task.

What happens:
The DF turns red but the flow does not then progress to the SQL task. It just stops.|||What I failed to mention was that the SQL task has 3 other failure paths joining it

I just set the precedence to "OR" instead of "AND" and it works.

error message?

I'm catching a primary constraint error in SQL and don't want to return the SQL error message back to the client. Is there any way to stop this. ThankyouCan you define "client" for me? Is the originator of the whole activity or the bit of code that's talking to SQL?|||Its returning the sql error message back to .net page, sorry!|||Do you have a data component or is the page talking to the Db directly?|||directly|||I figured it out thanks anyway!

Error message as a result of a DELETE

I'm executing a delete in a table and the result is the error 431:
Could not bind foreign key constraint. Too many tables involved in the query
.
There are no triggers associate with the table. What's this could be?
Thanks.
RenataHi
I assume this is a table! Are there any foreign keys referencing it?
John
"renata" wrote:

> I'm executing a delete in a table and the result is the error 431:
> Could not bind foreign key constraint. Too many tables involved in the que
ry.
> There are no triggers associate with the table. What's this could be?
> Thanks.
> Renata