Hi,

I have a source and destination connection and i want to be able to have
multiple Transform tasks running between the 2 connections in parallel. I
also need the destination connection to show a fail result if one or more of
the tasks fails, but this currently doesn't seem to be the case.... Does
anyone know how to achieve this if it's possible?

Thanks

Simon,

Multiple tasks utilizing the same connection(s) are executed sequentially.
It can be the same source or the same destination connection or both. Same
is true for execute sql task. The rule here is one connection can serve just
one process at a time.

Ilya

"Simon M" <SimonM (AT) discussions (DOT) microsoft.com> wrote