November 13, 2006 at 12:06 pm
Can we rename a DTS package after it has been created. If yes then how??
November 13, 2006 at 1:21 pm
Open the DTS package, do a Save As with the new name and delete the old package. Note that the new package will have just the latest version of the package.
November 14, 2006 at 1:45 am
Alternatively, to keep all your old versions under the new name, you can update the sysdtspackages table in msdb.
If you take the package GUID (available from the package properties), you can write an update query to update the name field in the sysdtspackages table in msdb (might want to wrap this up in a transaction just to be safe, or have a backup of msdb).
Don't forget to refresh your view of the Local Packages screen after the update and you should see the new name!
November 14, 2006 at 7:35 am
Sorry to butt in Phil. You cannot do that. Even if you change the name in sysdtspackages the designer still has the readonly only GUID and versionid which will not allow you to save the newly named package, which we modified in sysdtspackages.
for example
create a package pk1
rename it in sysdtspackages as pk2
open it in designer
try to save it again (you will get an error)
In my opinion/experience using 'Save As' is the best/safest option
jambu
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply