Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Deleting DTS packages in SS 7.0

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-07 : 21:34:51
Des writes "Re: SS 7.0 Enterprise edition, NT4.0 SP5.0 (Intel)

I want to delete some unwanted DTS packages that I have in the
repository, but the server just sits there and churns the disks, but the package won't go. I'm right clicking and selecting 'delete'.

Someone suggested I ran the following on the server from the command prompt, also tried it from inside QA using xp_cmdshell.

dtsrun -s server -e -r -n package_name -!D

But I still get the following error:

Error -2147217296 (80041070); Provider Error 0 (0)

Error string: The object cache is full
Error source:
Help file: c:\program files\common files\microsoft
shared\repostry\repostry.chm
Help context 4208.


Master & msdb databases and log files are NOT full.

Any ideas?

Des"
   

- Advertisement -