HI, I have a test package, designed for transactions in that package i ma inserting rows in to table Test it contains only one column that is name, that is primary key also, I have placed 5 Execute sql tasks in my package,the statements i ma using are insert into test values('111') For (EST 111) insert into test values('222') For (EST 222) insert into test values('111') For ( EST 111 F) insert into test values('333') For (EST 333) insert into test values('444') For (EST 444) my package design will be like this, EST 111 |(on success) EST 222 |(on success) EST 111 F (on success)| |(On Failure) EST 333 EST 444 In the package level I have applied transactions,by setting property transactionOption=required here i am getting error EST 444, Execute SQL Task: Failed to acquire connection "Conn1". Connection may not be configured correctly or you may not have the right permissions on this connection. I didn't get what happened there? Thanks in advance

sql serer database i am connected. DTC service is also unning all execute sql tasks are using same with same connection, and my EST 444 only showing error, because the name column is primary key the 3rd task EST 111f is getting failed and so before entries are getting roll backed, as precedence constraint have put on failure so that the task EST 444 is going to run, but it failed to acquire connection at that time, My question is, Will the DTC service terminate the connection also? I mean what exactly happens when the DTC service roll back the transaction? Thanks in advance RAVIKIRAN.M