Cannot delete a DTS package!!!

Hi all... I am running SQL Server 7.0 SP 1. I have two DTS packages saved to the repository that I cannot delete. When I try to delete them using EM I get an hourglass for about ten minutes then EM shuts down with no errors? When I start EM back up I still see the packages? If I query sysdtspackages it returns zero rows? HELP!!!! They will not go away!!!!

Thanks,
Jeff Boyd
Vistana Technology Group
(407) 465-3872
LVL 1
jboydAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
toddharmonConnect With a Mentor Commented:
Jeff,

This little snipet of VB code seemed to do the trick on my pesky DTS Packages.  I have not investigated the msdb database yet to make sure it is 'really' removed, but it no longer appears in Enterprise Manager.

Enjoy!

-t-

'dont forget to add appropriate DTS
'component references to your project
'first

Dim goPackage As New DTS.Package
Dim strServerName$, strLogin$, strPwd$, bTrusted As Boolean
Dim strPkgGuid$, strPkgVersion$, strPkgName$

    Set goPackage = Nothing
   
    strServerName = "(local)"
    strLogin = "sa"
    strPwd = ""
    bTrusted = False
    If strLogin = "" Then bTrusted = True
   

    Dim strPkgID
    strPkgID = InputBox("Enter the package guid from the package properties dialog of the DTS Designer")
   
    If MsgBox("Delete package: " & strPkgID, vbYesNo) = vbYes Then
        goPackage.RemoveFromRepository strServerName, "msdb", strLogin, strPwd, strPkgID
        MsgBox "Deleted (hopefully)!", vbOKOnly
    End If
0
 
jboydAuthor Commented:
Adjusted points to 200
0
 
VRGPALCommented:
hi

Check the name of the DTS package, because only when the package is scheduled , there will be an entry in the sysdtspackages, or else there would be any entry in sysdtspackages

regards

Ravigopal(VRG)
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
jboydAuthor Commented:
Yes. I realize now that there should not be an entry in sysdtspackages. However, I still have the problem where I cannot delete my DTS packages stored in the repository.
0
 
MFKCommented:
Check your \Mssql7\Binn folder for the DTS package file. If it is there then delete that file.
0
 
MFKCommented:
Sorry, I meant to submit that as a Comment. I do apologise...
0
 
jboydAuthor Commented:
The package was not saved to a file it was save to the repository which is really a structure of tables in the msdb database.
0
 
sudhi022299Commented:
This might be one of the reasons to it:

http://support.microsoft.com/support/kb/articles/Q245/2/53.ASP?LNG=ENG&SA=MSDN

Regards,
Sudhi.
0
 
jboydAuthor Commented:
Not the problem. I can see and edit the packages. I can even delete everything in the packages and save them, but I cannot delete the packages from the repository.
0
 
sudhi022299Commented:
Try rebuilding the repository tables.

Regards,
Sudhi.
0
 
jboydAuthor Commented:
But then I would have to recreate all my other DTS packaghes that I am not trying to delete.
0
 
sudhi022299Commented:
sorry for not checking this. i was little bit busy.

Take a backup of the msdb, rebuild the repository and then if it still doesn't work then , restore the msdb database from the backup.

Regards,
Sudhi.
0
 
toddharmonCommented:
Jeff,

any luck with this issue?  we're seeing this for the first time on a test box... i'd rather not have to rebuild if there's another solution...

Thanks!

-t-
0
All Courses

From novice to tech pro — start learning today.