In my case the problem was only on the items in the data flow task where the "[highlight=#ffff11]Check Constraints[/highlight]" option was selected for the OLE DB Destination. Once I change...

You got it right!

Thank for the info. The degraded performance while both nodes are failed over to the same instance is something that I anticipated anyway.

Do you actually have a...

I have the same problem and questions. I inherited the same type of environment. I hope someone answers this thread.