dbTalk Databases Forums  

Delete DTS package from SS 2005 msdb database

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Delete DTS package from SS 2005 msdb database in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
peter.davey@austin.org.au
 
Posts: n/a

Default Delete DTS package from SS 2005 msdb database - 08-06-2008 , 06:00 PM






G'day,
I have a DTS package that I store in a SS2000 server which I've also
saved into a SS2005 server. I've modified the package using
Enterprise Manager and want to re-save the modified version into the
SS2005 instance but it returns an error: "DTS package '<package name>'
already exists with a different ID in this category"

I ran a query against the sysdtspackages table in both the SS2000 and
SS2005 DBs and the owner is the same. I'm using Windows
Authentication on both servers. I suspect I could resolve this by
deleting the existing package from the SS2005 DB before I save the
modified version but I don't know how to do this as Enterprise Manager
doesn't work with SS2005 and I can't work out how to do it using
Management Studio or Visual Studio.

Any help would be greatly appreciated.

cheers
peterD


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.