Hi,

I have a main DTS package that contains 3 Execute Tasks
for 3 DTS packages. The 3
execute tasks are started simultaneously and they all Join
transaction from the main package.
The main package is supposed to call the 3 DTS packages,
that would insert data in 3 tables, and then
the main package will insert data in another table
accordingly.
When I run the main package without using transaction on a
large set of data (40,000) everything
works well. When I run it using transaction on the same
number of records, it starts out fine
but then 2 of the DTS packages gets stuck. However, if I
run the main package using transaction but for
a few records, the main packages completes successfuly.
Any ideas or hints about what could be causing this
problem is appreciated.

Thanks,
Grace