Hi,
Is there any way to programatically rename all DTS packages on a server
to 'New_'+ old_name or save them all as 'New_'+ old_name
(and then I can delete the old ones)
Thanks

In message <1122915475.014134.296550 (AT) z14g2000cwz (DOT) googlegroups.com>,
polinaskulski (AT) aol (DOT) com writes
You can use the DTS object model to load and save packages.

Have a look at the "Transfer Packages Sample Application" here as a
start point-

Tools & Tasks
(http://www.sqldts.com/default.aspx?272)


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

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

Hi,
I use it but I cannot save DTS with the different name.

In message <1122924319.313752.129200 (AT) g14g2000cwa (DOT) googlegroups.com>,
polinaskulski (AT) aol (DOT) com writes
Look at the SaveToSQLServerAs method.

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

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

Have you tried to rename items in the packages tables in the msdb database?

Rick

<polinaskulski (AT) aol (DOT) com> wrote

In message <eIZWvb6lFHA.2380 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Rick Gittins
<rgittins (AT) dungarvin (DOT) com> writes
Don't bother, it renames the packages you see in the EM list, but that
will be overwritten the next time you save the package as the name is
stored in the object model, the image column, so it cannot fudged
through T-SQL.


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

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