some questions to think about:

1. Is the old database still up? Did you run the migration tool on it?

2. Don't the subscripts imply position in a column...

Certainly sounds like the classical overflow problem. Can you retype the sum, if not the underlying values, into a larger capacity?

Can you describe what you think your DECLARE is doing?

You can use increments other than +1 or -1, but I believe they need to be integer. You...

I suspect there's a problem with the hotfix. Other posts discuss problems where the hotfix had to be rolled back.

your query references "remotesvr" - how is that defined? The name is "cunet", no? If it's not fully qualified, that could explain. Also, if there's more than...

IF you are moving actual database files, that's true. However, if these are flat files, there's no such constraint.

Are you suffering a 'notational' foul? is the table name in some way a reserved word, or some other such feature that the remote execution could run afoul of?...

Closing thoughts:

SQL Server updates are supposed to be cumulative. Since your network guys didn't use the usual channel, they may have inadvertantly rolled back a patch, but...

I'm sticking my neck out here, Janice, but I have some thoughts...

1.  What other types of errors would cause shipping a file to the failure folder?  If there aren't any,...

If, instead of searching for 'MSDTSServer', you search for MS DTS Server, you will have much greater success. 

As to why only one plan failed, it may have to do...

Did you check the Microsoft reference links you cited? when i went there, they specified that no further information was available!

(revised for clarity - the MS support posts indicated...

'Connect to the server from client' - meaning not logging on physically from the server, right? (either at console or remoting in)

HOW are you connecting?  command line?  front end?  You...

FWIW, Chris had a solution that should work, except that the '>' should be '<'.  You may want to try that, just to know that we're not ALL crazy here...

You are running Upgrade Advisor as a prudent way to forecast issues on switch to 2005 (good for you!).  Your client gave you a week's notice, because you built SPs...

I'm impressed that no one has suggested putting the database on a diet!  If the database is constantly active, and constantly having growth, then at some point, no matter what...