dbTalk Databases Forums  

How do I grant execute/edit for a DTS package?

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts How do I grant execute/edit for a DTS package?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss How do I grant execute/edit for a DTS package? in the microsoft.public.sqlserver.dts forum.



Reply
Page 4 of 4 < 1 2 3 4
 
Thread Tools Display Modes
  #31  
Old   
Elidas
 
Posts: n/a

Default Re: How do I grant execute/edit for a DTS package? - 03-05-2008 , 03:28 AM





Thanks, it seems to work correctly now

"Russell Fields" wrote:

Quote:
Elidas,

From SQL Server 2000 Enterprise Manager, when you save a DTS package it
gives you 3 options:

SQL Server
Structured Storage File
Visual Basic File

If you choose Structured Storage File, it will ask you for a File Name
(actually the full path and file name) where the file should be stored.
Since we almost always do it this way, it allows a team to manage the
contents of the package rather than having one person with rights. There are
some policy decisions that you will have to make, this is just a technical
comment.

If the file already exists in SQL Server (in the msdb database), simply edit
it and save it as a Structured Storage File. Any jobs that are running the
msdb version will need to be updated to point to the file if you want to
start using the file version.

RLF

"Elidas" <Elidas (AT) discussions (DOT) microsoft.com> wrote in message
news:C7CCC7FE-8B6F-430F-9B7C-C46EAB35AF24 (AT) microsoft (DOT) com...
Thanks, but, how do I store in a different location than msdb? I though
that
all DTS must be in msdb database

"Russell Fields" wrote:

Elidas,

If you store your DTS Package in msdb, then it is under those msdb
security
rules and elevated rights are needed.

However, if you store your DTS Package in structured file storage, then
it
is under file system security. You can keep it in a folder where two or
more people have rights to edit the package.

Alternatively, if you want to keep it in msdb, you could always use a
special shared login to edit that package. Then whoever has the password
to
the shared login could login, edit the package, then log back out. (I
don't
really like this one, but maybe you would.) Again, the shared login
would
own the package so anyone else would need elevated rights to change the
package.

RLF

"Elidas" <Elidas (AT) discussions (DOT) microsoft.com> wrote in message
news:F2E155F2-FF34-4AE0-BF0B-50CCF760F022 (AT) microsoft (DOT) com...
Hi, I have created a DTS Package in SQL Server 2000, is there any way
that
a
different user can edit and execute that DTS WITHOUT having server
roles
or
privileges?


Thanks

Reply With Quote
  #32  
Old   
Elidas
 
Posts: n/a

Default Re: How do I grant execute/edit for a DTS package? - 03-05-2008 , 03:28 AM





Thanks, it seems to work correctly now

"Russell Fields" wrote:

Quote:
Elidas,

From SQL Server 2000 Enterprise Manager, when you save a DTS package it
gives you 3 options:

SQL Server
Structured Storage File
Visual Basic File

If you choose Structured Storage File, it will ask you for a File Name
(actually the full path and file name) where the file should be stored.
Since we almost always do it this way, it allows a team to manage the
contents of the package rather than having one person with rights. There are
some policy decisions that you will have to make, this is just a technical
comment.

If the file already exists in SQL Server (in the msdb database), simply edit
it and save it as a Structured Storage File. Any jobs that are running the
msdb version will need to be updated to point to the file if you want to
start using the file version.

RLF

"Elidas" <Elidas (AT) discussions (DOT) microsoft.com> wrote in message
news:C7CCC7FE-8B6F-430F-9B7C-C46EAB35AF24 (AT) microsoft (DOT) com...
Thanks, but, how do I store in a different location than msdb? I though
that
all DTS must be in msdb database

"Russell Fields" wrote:

Elidas,

If you store your DTS Package in msdb, then it is under those msdb
security
rules and elevated rights are needed.

However, if you store your DTS Package in structured file storage, then
it
is under file system security. You can keep it in a folder where two or
more people have rights to edit the package.

Alternatively, if you want to keep it in msdb, you could always use a
special shared login to edit that package. Then whoever has the password
to
the shared login could login, edit the package, then log back out. (I
don't
really like this one, but maybe you would.) Again, the shared login
would
own the package so anyone else would need elevated rights to change the
package.

RLF

"Elidas" <Elidas (AT) discussions (DOT) microsoft.com> wrote in message
news:F2E155F2-FF34-4AE0-BF0B-50CCF760F022 (AT) microsoft (DOT) com...
Hi, I have created a DTS Package in SQL Server 2000, is there any way
that
a
different user can edit and execute that DTS WITHOUT having server
roles
or
privileges?


Thanks

Reply With Quote
  #33  
Old   
Elidas
 
Posts: n/a

Default Re: How do I grant execute/edit for a DTS package? - 03-05-2008 , 03:28 AM


Thanks, it seems to work correctly now

"Russell Fields" wrote:

Quote:
Elidas,

From SQL Server 2000 Enterprise Manager, when you save a DTS package it
gives you 3 options:

SQL Server
Structured Storage File
Visual Basic File

If you choose Structured Storage File, it will ask you for a File Name
(actually the full path and file name) where the file should be stored.
Since we almost always do it this way, it allows a team to manage the
contents of the package rather than having one person with rights. There are
some policy decisions that you will have to make, this is just a technical
comment.

If the file already exists in SQL Server (in the msdb database), simply edit
it and save it as a Structured Storage File. Any jobs that are running the
msdb version will need to be updated to point to the file if you want to
start using the file version.

RLF

"Elidas" <Elidas (AT) discussions (DOT) microsoft.com> wrote in message
news:C7CCC7FE-8B6F-430F-9B7C-C46EAB35AF24 (AT) microsoft (DOT) com...
Thanks, but, how do I store in a different location than msdb? I though
that
all DTS must be in msdb database

"Russell Fields" wrote:

Elidas,

If you store your DTS Package in msdb, then it is under those msdb
security
rules and elevated rights are needed.

However, if you store your DTS Package in structured file storage, then
it
is under file system security. You can keep it in a folder where two or
more people have rights to edit the package.

Alternatively, if you want to keep it in msdb, you could always use a
special shared login to edit that package. Then whoever has the password
to
the shared login could login, edit the package, then log back out. (I
don't
really like this one, but maybe you would.) Again, the shared login
would
own the package so anyone else would need elevated rights to change the
package.

RLF

"Elidas" <Elidas (AT) discussions (DOT) microsoft.com> wrote in message
news:F2E155F2-FF34-4AE0-BF0B-50CCF760F022 (AT) microsoft (DOT) com...
Hi, I have created a DTS Package in SQL Server 2000, is there any way
that
a
different user can edit and execute that DTS WITHOUT having server
roles
or
privileges?


Thanks

Reply With Quote
Reply
Page 4 of 4 < 1 2 3 4

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top