SQL 2000, sp4. There are about 300 old DTS packages created by former
programmer. I used "sp_reassign_dtspackageowner" to change owner of the
packages and all owners have be changed to my name. But when I make any
change to existing package, the owner name changed to former programmer.

Is there any way I can change the name permanently? I saw a methord by
saving all packages with new name but it takes too much time for 300 packages.

Thanks.

Yes...that's normal but package ownership is generally not
really an issue. Refer to the following article for more
information:
Package Ownership Issues
http://www.sqldts.com/default.aspx?212

-Sue

On Tue, 9 Aug 2005 07:27:50 -0700, "Shirley"
<Shirley (AT) discussions (DOT) microsoft.com> wrote:

You could created an external program in VB that would take each DTS and do
a Save As for each of the 300 that you have.

Rick

"Shirley" <Shirley (AT) discussions (DOT) microsoft.com> wrote