I have a DTS which used to work fine till couple of weeks ago.

I've done no changes to the code.

The DTS is using two SQL servers. The main one is doing remote queries (reads, updates and inserts) on the second one.

There are few steps doing differential inserts on the second server, and I'm making joins between a master table on the primary server and the destination table on the other machine.

I've started to encounter (random) deadlocks in the steps dealing with remote queries. The last action on the blocking SPID was 'sp_unprepare'.

I've read that this issue may be related with orphaned sessions (http://www.databasejournal.com/featu...le.php/1441081) , and therefore I guess I may have a network error.

Any suggestions?

Thanks a lot,