Rename | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Rename

HI
Is there any way to rename a DTS Package. Thanks!
"He laughs best who laughs last"
I guess no.
But you can go to design package and save it as diffrent name which you wanted on SQL Server and then delete the older one.
You can rename packages by modifying the system tables. I would never advise altering them directly in the
system tables so one way of doing it is to open the packages
programmatically and save them out to the new name.
—————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

True and if you attempt to rename system tables data, it may lose consistency and lead to another issues. I agree with Dinesh’s approach. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Check out www.sqldts.com —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

I think I have to go do the design mode and rename it to different name, then have to delete old one. I hope this is the only way we can do.
Thanks for your input. Thanks!
"He laughs best who laughs last"
]]>