|
| 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
|
|