Resetting DTS password

Hi all,
can anybody please how to reset passwords for an DTS? I need to edit and run
it...but the former DBA left without giving us the passwords...
Thanks,
Tudor
Hi Tudor - I would change the owner of the package.
We run/own all our packages under a 'pretend' domain account reservd for
SQL - this is also the account that SQL and SQL agent run under.
Hope this helps.
"Tudor Sofron" <tsofron@.cluj.astral.rom> wrote in message
news:O0fjbohpEHA.868@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> can anybody please how to reset passwords for an DTS? I need to edit and
run
> it...but the former DBA left without giving us the passwords...
> Thanks,
> Tudor
>
|||Doesn't help. I can't do that until i open the package...What I need is to
change the owner password of the dts...
Tudor
"Allen Davidson" <allen.davidson@.europe.mccann.com> wrote in message
news:eoaY3vhpEHA.1296@.TK2MSFTNGP12.phx.gbl...
> Hi Tudor - I would change the owner of the package.
> We run/own all our packages under a 'pretend' domain account reservd for
> SQL - this is also the account that SQL and SQL agent run under.
> Hope this helps.
> "Tudor Sofron" <tsofron@.cluj.astral.rom> wrote in message
> news:O0fjbohpEHA.868@.TK2MSFTNGP10.phx.gbl...
> run
>
|||Hi Tudor - in this case I think you are stuck.
The pakage will be stored in encrypted form and without the owner password I
don't think you can do anything (anything at all usefull) with it.
Allen
"Tudor Sofron" <tsofron@.cluj.astral.rom> wrote in message
news:eG$U24hpEHA.3520@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Doesn't help. I can't do that until i open the package...What I need is to
> change the owner password of the dts...
> Tudor
>
> "Allen Davidson" <allen.davidson@.europe.mccann.com> wrote in message
> news:eoaY3vhpEHA.1296@.TK2MSFTNGP12.phx.gbl...
and
>