Change owner of a DTS package?

I saved a dts package as a structured file from one SQL
server, then imported to another SQL server. Now, how can I
change the owner of that new package from me to dbo?
Thanks
--
E-mail correspondence to and from this address may be
subject to the
North Carolina Public Records Law and may be disclosed to
third parties.If I understood your question correctly, dts owner is
different than database user. You can specify dts owner
password who can modify the package, and a user password
who can execute it.
To change these passwords you have to save it again with
another name, after opening the dts package in dts
designer, click on Package->Save As, there you can enter
the new passwords.
hth.
>--Original Message--
>I saved a dts package as a structured file from one SQL
>server, then imported to another SQL server. Now, how
can I
>change the owner of that new package from me to dbo?
>Thanks
>
>--
>E-mail correspondence to and from this address may be
>subject to the
>North Carolina Public Records Law and may be disclosed to
>third parties.
>
>.
>|||Thanks, but maybe if I explain more fully you'll be able to
help me.
Joe developer created a dts package on 'oldserver'. The
package was owned by domain\joe. We needed to move the
database that Joe was working in to another server. I did a
backup from 'oldserver' and then restored the database to
'newserver'. Of course Joe's dts packages were not moved by
the backup/restore. I opened his dts packages on 'oldserver'
and did a "save as" with location = SQL Server and the Server=newserver. This moved the packages from oldserver to
newserver. The packages were owned by domain\tom on the
newserver. I'd like to change the package owner from
domain\tom to dbo or even to domain\joe would be ok. Surely
there must be some way to simply change the owner of a dts
package!?
Since then, I've just had Joe to the 'save as' to the new
server. That has solved the immediate problem. I'd still
like to know how to change the package owner.
Thanks
Tom
brian wrote:
> If I understood your question correctly, dts owner is
> different than database user. You can specify dts owner
> password who can modify the package, and a user password
> who can execute it.
> To change these passwords you have to save it again with
> another name, after opening the dts package in dts
> designer, click on Package->Save As, there you can enter
> the new passwords.
> hth.
> >--Original Message--
> >I saved a dts package as a structured file from one SQL
> >server, then imported to another SQL server. Now, how
> can I
> >change the owner of that new package from me to dbo?
> >
> >Thanks
> >
> >
> >--
> >E-mail correspondence to and from this address may be
> >subject to the
> >North Carolina Public Records Law and may be disclosed to
> >third parties.
> >
> >
> >.
> >
--
E-mail correspondence to and from this address may be subject
to the
North Carolina Public Records Law and may be disclosed to
third parties.|||In most cases, the package owner doesn't really matter and
can be ignored. You can find information on the subject in
the Package Ownership Issues article on sqldts.com:
http://www.sqldts.com/default.aspx?212
-Sue
On Wed, 08 Oct 2003 15:04:20 -0400, Tom Williams
<Tom.Williams@.ncmail.net> wrote:
>Thanks, but maybe if I explain more fully you'll be able to
>help me.
>Joe developer created a dts package on 'oldserver'. The
>package was owned by domain\joe. We needed to move the
>database that Joe was working in to another server. I did a
>backup from 'oldserver' and then restored the database to
>'newserver'. Of course Joe's dts packages were not moved by
>the backup/restore. I opened his dts packages on 'oldserver'
>and did a "save as" with location = SQL Server and the Server=>newserver. This moved the packages from oldserver to
>newserver. The packages were owned by domain\tom on the
>newserver. I'd like to change the package owner from
>domain\tom to dbo or even to domain\joe would be ok. Surely
>there must be some way to simply change the owner of a dts
>package!?
>Since then, I've just had Joe to the 'save as' to the new
>server. That has solved the immediate problem. I'd still
>like to know how to change the package owner.
>Thanks
>Tom
>
>brian wrote:
>> If I understood your question correctly, dts owner is
>> different than database user. You can specify dts owner
>> password who can modify the package, and a user password
>> who can execute it.
>> To change these passwords you have to save it again with
>> another name, after opening the dts package in dts
>> designer, click on Package->Save As, there you can enter
>> the new passwords.
>> hth.
>> >--Original Message--
>> >I saved a dts package as a structured file from one SQL
>> >server, then imported to another SQL server. Now, how
>> can I
>> >change the owner of that new package from me to dbo?
>> >
>> >Thanks
>> >
>> >
>> >--
>> >E-mail correspondence to and from this address may be
>> >subject to the
>> >North Carolina Public Records Law and may be disclosed to
>> >third parties.
>> >
>> >
>> >.
>> >