SQL Server says DTS does not exist when it does

[bigfoot]

I created a DTS package and I can see it under Data Transformation Services, but I can't open it.
It gives me this error.

First Dialog:
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : The specified DTS Package ('Name = 'im_Import_textfile'; ID.VersionID =
{8AE74335-C970-4219-B619-2D250031463C}.{[not specified]}') does not exist.

Next dialog:
The selected package cannot be opened. The DTS Designer has been closed.


I am using the same machine I created it on. And the #2 and #3 versions open ok.

Any place I can go into a table somewhere and delete the entry? That is after I save it to another server.

Thank God I saved it with a number so I only lost the first revision.

 

[mrdenny]

You should be able to right click on it and delete it.

If that doesn't work backup the msdb database and try to delete it from the msdb.dbo.sysdtspackages table.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[bigfoot]

Thanks.

Weird. This morning it opened just fine.

Makes me wonder....