I wonder if I'm missing something simple.

I can't figure out how to rename a DTS packages (and I have a number
that I want to rename).

I couldn't figure out how to do it in the Enterprise Manager
interface, so I tried writing a program against SQLDMO object model,
but I always get a COM error trying to rename a package (local server
package).

The only way I can figure out to do it is (quite painfully) to
recreate the entire package from scratch. This is quite painful
because

1) I also can't figure out how to copy the contents from the old DTS
package and paste them into the new one (the one with the new name) --
when I try to copy the contents, I get a DTS designer error saying
select only one item. Obviously I want to copy all the items, not
manually one at a time (plus, I don't know how copying workflow would
work if I have to copy each item individually).

2) This sounds like another call for SQLDMO programming, but, I wonder
if everyone else hasn't run into this same problem, and if there is an
answer already available -- does anyone (eg, Microsoft) post a SQLDMO
script to solve this ?


(Or, is there a simple solution that I'm just overlooking ?)

In Enterprise Manager, open up the package in Design mode.

In the menu, click Package | Save As ..

Type in your new package name, and click OK.

Now you will have two packages: one with the old name, and one with the new
name.





"pj" <peterjohannsen (AT) hotmail (DOT) com> wrote

DTS has nothinig to do with DMO. It has it's own object model. There is no
rename method. You need to do a Save As


--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"pj" <peterjohannsen (AT) hotmail (DOT) com> wrote

peterjohannsen (AT) hotmail (DOT) com (pj) wrote in message news:<127ce4a9.0309110609.f4b572 (AT) posting (DOT) google.com>...
Sorry, I got mixed up. I know how to Save As to rename a package, but
that doesn't really rename a package. That duplicates it to a new one
(so, I do know how to duplicate a package -- I was confused before!)

I want to rename the package, not duplicate it, because when you
duplicate it, AFAICT, you lose all the history -- all the package
logs. I don't know if you also lose all metadata lineage history ? But
what I care about is losing all the log history -- the logs would be
more useful to me if I were allowed to use them and also to rename
packages.


PS: Re: SQLDMO & DTS
Oh, yes, DTS is a different typelib -- good point -- but I use SQLDMO
to get to the objects which I then query using DTS typelib methods. I
think of the whole thing as using SQLDMO, which is maybe
insufficiently accurate.


I wish Microsoft would identify a package by a GUID, say, and let the
name just be a user-visible & editable string -- I assume that is the
modern way to handle that. I'm somewhat surprised it doesn't work that
way now -- they use GUIDs in a lot of places.

In article <127ce4a9.0309111250.15b663ce (AT) posting (DOT) google.com>, pj
<peterjohannsen (AT) hotmail (DOT) com> writes
They do use GUIDs for both packages and versions of, and they are the
what really matter, but unfortunately there is no way to change the name
still. In short there is no rename, just Save As (duplicate!).

The logs, I assume you mean the logs stored in SQL Server are just use
tables really, so you could kludge the name/guid in those tables to
match that of your new package. What you would loose is any old versions
of a package.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

did you try Save As?
drew

out on SQLDTS.com is a utility called backupdts I think, that will let you
extract and restore just what you want.
hth
drew