URGENT : "The AcquireConnection method call failed with error code 0xC0202009" when configuring transaction

Hi all,

I have 2 SSIS packages.

The first package calls the second one in a for loop.

The inner package contains several tasks (execute SQL task which runs stored procedures, and data flow tasks which transfer data from one SQL server 2000 database to another SQL server 2000 database).

The packages worked fine until I tried to add a transaction to the flow: I configured the main package "transaction option" to be "required" and the inner package to be "supported" (all the tasks in both of the packages are "supported" too).

When I run the package, it fails on the error: "The AcquireConnection method call failed with error code 0xC0202009". The error happens in the inner package, on one of the data flow tasks, immediately when the task begins. The data flow task contains several couples of select statement from the first DB and insert to the second DB, all of them happen simultaneously. Before this data flow task I have a few similar tasks that work properly.

I tried:

1) Changing the order of the tasks.

2) Changing the "retainSameConnection" property to "true".

3) Changing the isolation level from "serializable" to "read uncommitted".

None of them worked.

Any ideas

Please answer me quickly this is urgent.

Thanks in advance,

Shira.

shira_w@walla.com