DTS Error

[DrewConn]

I have a DTS job to move an entire DB from a SQL 7.0 box to a 2000 SQL server. I keep getting the following error:

Need to run the object to perform this operation
[SQL-DMO]Code excecution exception: EXCEPTION_ACCESS_VIOLATION

I have tried testing the job using different DB's and get the same error so I'm thinking it is a server level issue rather than a DB issue.

Any idea's?

Thanks.

 

[DrewConn]

Just posting the solution to my own problem in case someone gets the same error.

Had to do with the server name being corrupted, so server name was null. DTS couldn't find the requested server.

Can fix with select @@servername to see if null, if so
run sp_dropserver <servername>
run sp_addserver <servername>,local

then restart services and problem is resolved.