Package runs forever on 1 server and fine on another?

[razorhazor]

Hi,

I've got a DTS Package which data pumps data from some SQL which references several tables into another table to form a stored results table.

The package runs fine on one server but runs infinite on the other server and doesnt finish (thats the data pump step). Both servers are exactly the same and both databases are the same???

Help!

Cheers
Matt

 

[DrSql]

Verify the any spid locks and connections.

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[razorhazor]

That was the first thing I checked, unfortunately no locks, checked with sp_who2 and no blocking at all :-(