Can't Delete Meta Data Services Packages (Repost: No response on DTS SQL NG.)

Hey guys,
I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
hang EM when I try to delete them. I could try using the /!D parameter of
DTSRUN but that might take a while as I'm sure there are multiple versions
for each. Is this a known issue or is there a quick way to delete these
packages (including the multiple versions for each)?
Thanks
JerryYeah...people have hit the issue. Sometimes it's due to a
corrupt repository - there is a KB article on how to rebuild
it. I'd try running the !D. If you hit issues due to the
number of versions, you would like get some error about the
cache being full...something along those lines. There are
registry hacks others have used to fix that issue. But I'd
just first try going through and deleting with !D
-Sue
On Tue, 16 May 2006 11:22:08 -0700, "Jerry Spivey"
<jspivey@.vestas-awt.com> wrote:

>Hey guys,
>I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
>hang EM when I try to delete them. I could try using the /!D parameter of
>DTSRUN but that might take a while as I'm sure there are multiple versions
>for each. Is this a known issue or is there a quick way to delete these
>packages (including the multiple versions for each)?
>Thanks
>Jerry
>

Can't Delete Meta Data Services Packages (Repost: No response on DTS SQL NG.)

Hey guys,
I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
hang EM when I try to delete them. I could try using the /!D parameter of
DTSRUN but that might take a while as I'm sure there are multiple versions
for each. Is this a known issue or is there a quick way to delete these
packages (including the multiple versions for each)?
Thanks
JerryYeah...people have hit the issue. Sometimes it's due to a
corrupt repository - there is a KB article on how to rebuild
it. I'd try running the !D. If you hit issues due to the
number of versions, you would like get some error about the
cache being full...something along those lines. There are
registry hacks others have used to fix that issue. But I'd
just first try going through and deleting with !D
-Sue
On Tue, 16 May 2006 11:22:08 -0700, "Jerry Spivey"
<jspivey@.vestas-awt.com> wrote:
>Hey guys,
>I've got serveral SQL Server 2000 (SP4) Meta Data Services Packages that
>hang EM when I try to delete them. I could try using the /!D parameter of
>DTSRUN but that might take a while as I'm sure there are multiple versions
>for each. Is this a known issue or is there a quick way to delete these
>packages (including the multiple versions for each)?
>Thanks
>Jerry
>

Can't create new SSIS package in VS 05

Is there anyone out there that can help me - please! I'm about to put my head through a wall.

I used to be able to create SSIS packages in VS 05. It's been a while since I've done it, but when I went in the other day, it would let me - all I can do is get errors. It tells me an "error prevented the view from loading" when it opens in control flow (blank packages and ones I created before all this started) and I get this error :

"Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (System.Windows.Forms)"

If I go over to the Data Flow tab and there are no errors until I click "Click here to add a new Data Flow task", then I get this :

"Object reference not set to an instance of an object. (Microsoft.DataTransformationServices.Design)"

So... here's what I've tried.

Uninstalled and reinstalled VS 05 and SP1 (this was before I realized the problem was with SQL).

Uninstalled and reinstalled Office 2003 Web Tools.

Made sure all the MSXMLs were registered.

Uninstalled and reinstalled all SQL Servers and Tools/Components.

Made sure all SQL Services were running under Local Account

Made sure Integrated Services service was running.

Applied all SQL patches.

I cannot get this to work and I need to be able to create packages. The only other step I can think of is wiping my computer and I don't want to have to do that.

Please please can anyone help me? I've been scouring the internet and working on this for 1 day and 1/2.

Miraculously - it's started working again. All I've done since then is go to the MS Update website and tried to add SQL 2005 SP2 again. It failed again, but this time when I opened my SSIS project, it opened ok.

I also just realized that I disabled the antivirus on my computer in an attempt to upgrade to SP2 again (although I haven't tried to upgrade the second time), but the antivirus is still off - When I reboot, I'll try to open it again - of it fails it must be the antivirus.

|||

Well, it wasn't the antivirus, because I've rebooted and it's still working - with the antivirus running. So if anyone else is running into this issue and is reading this thread for help - sorry - don't know what to tell you or how it fixed itself.

All I know is - you live by Microsoft, you die by Microsoft.