Wednesday, March 7, 2012

DTS owner password

Hi,
Can i assign a owner password to a especified package
without recreating the package ?
Thanks a lot
MikeHI,
Open the Package and use the option SAVE AS and provide the Owner password.
In this case you will need to give a new name for this package.
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:14e5801c41c8e$87f3eba0$a001280a@.phx
.gbl...
> Hi,
> Can i assign a owner password to a especified package
> without recreating the package ?
> Thanks a lot
> Mike|||There's no other option ' I don't want to rename my
DTS's, i have references to it.

>--Original Message--
>HI,
>Open the Package and use the option SAVE AS and provide
the Owner password.
>In this case you will need to give a new name for this
package.
>Thanks
>Hari
>MCDBA
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
> news:14e5801c41c8e$87f3eba0$a001280a@.phx
.gbl...
>
>.
>|||You can but you need to be careful with it.
Open up the package and leave the window open. Then go back
to Enterprise Manager (with the package window still open)
and delete the package in Enterprise Manager. Now the
package will be available in memory from having the window
open but you will be able to Save As with the same name as
you just deleted the package in Enterprise Manager. Now go
back to the package window you have open and do the save as
with the password and you won't need to change the package
name.
In terms of the references to it, if you have any execute
package tasks that are calling this package, they will have
problems as the save as changes the GUID for the package
which is what the execute package tasks typically bind to in
referencing the other packages it executes.
-Sue
On Wed, 7 Apr 2004 04:24:22 -0700, "Mike"
<anonymous@.discussions.microsoft.com> wrote:
>There's no other option ' I don't want to rename my
>DTS's, i have references to it.
>
>the Owner password.
>package.
>message

No comments:

Post a Comment