If transferring multiple tables between source connection and destination
connection I can create these connections once and then define multiple
tasks between those two connections, but I don't appear to have any control
over sequence or "only do this if this other has succeeded".

If I create separate connections per task then I can control sequence and
continue/halt logic, but this requires me to keep recreating the same two
connection objects over and over again.

Is there a way to copy the connections that I have already created or to
control the sequence of multiple tasks that are using the same connections?

TIA

Rick,

You can create precedence constraints between two connection bound tasks so
they execute sequentially.

Ilya

"Rick Brandt" <rickbrandt2 (AT) hotmail (DOT) com> wrote