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

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C7CCC7FE-8B6F-430F-9B7C-C46EAB35AF24@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F2E155F2-FF34-4AE0-BF0B-50CCF760F022@xxxxxxxxxxxxxxxx
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





.

Relevant Pages

  • Re: Anyone running FCP on an Intel?
    ... package related support. ... Mr Editor to re-do certain parts (he isnt doing it for free since he didnt ... Oh wait, I dont own FCP ... want them all to use Speed Edit or even Vegas since I own them. ...
    (rec.video.desktop)
  • Re: Saving SSIS Packages
    ... I tried using the import wizard, importing a file based package and migrating ... Is DTC required for importing into msdb? ... When using the import wizard in SQL Server Management Studio, ... Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, ...
    (microsoft.public.sqlserver.dts)
  • Re: Abbrevia for Delphi2007 - zipping/unzipping Winzip files
    ... Edit B304_vr2007.dpk ... Compile the package ... What do I edit to make this work with Delphi 2007 ?? ... know how to install Abbrevia to work with Delphi 2007 ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Existence of Package.
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... SysDtsPackages but this needs a permission on msdb. ... before trying to load the Package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Loading DTS Packages
    ... By export do you mean to Structured Storage File? ... Transformation Services folder | Open Package) now navigate to the file. ... Allan Mitchell MCSE,MCDBA, www.SQLDTS.com - The site for all your DTS needs. ... How do I load>th> packages into another SQLServer. ...
    (microsoft.public.sqlserver.dts)
Loading