Monday, March 26, 2012

Saving DTS

Hello,
I=B4m saving one DTS with one user that was created only to=20
execute DTS's (Login: UserDTS Password:********).=20
When i look at the DTS it shows me that the owner of the=20
DTS is my user(the user that initiate the session in the=20
domain)(DOMAINX\myuser).
When i query the "msdb..sysdtspackages" the owner of the=20
DTS is the same that i see in the Enterprise Manager
(obvous). So, where can i see information about the users=20
that were used to save the DTS's?
I am thankful that you can help me.
Best regards
You can save a package with an owner password or a user
password. The owner is the creator of the package - the
login that created the package. There is no option to save
the package and have it owned by a login other than the
current login. Entering a password in the owner password or
user password options doesn't affect who owns the package -
it's just requires that whoever accesses the package needs
to provide the password for editing or executing the
package.
-Sue
On Fri, 2 Apr 2004 02:55:01 -0800, "CC&JM"
<anonymous@.discussions.microsoft.com> wrote:

>Hello,
>Im saving one DTS with one user that was created only to
>execute DTS's (Login: UserDTS Password:********).
>When i look at the DTS it shows me that the owner of the
>DTS is my user(the user that initiate the session in the
>domain)(DOMAINX\myuser).
>When i query the "msdb..sysdtspackages" the owner of the
>DTS is the same that i see in the Enterprise Manager
>(obvous). So, where can i see information about the users
>that were used to save the DTS's?
>I am thankful that you can help me.
>Best regards
sql

No comments:

Post a Comment