I have two SQL 2000 servers, Db1A and Db1B. There has been NO SQL 2005/2008 is or has ever been involved and in the past and has all be working fine, last week.
On Db1B I can use it's SQL Enterprise Manager and I can see both servers. I can also open up all DTS packages on both Db1A and Db1B, form the 'B' server. However on Db1A, I can open and edit some, of my DTS packages and not all of them. The DTS packages which fail on Db1A, all fail with this error:
"The selected package cannot be opened. The DTS Designer has been closed."
How can you fix it?