Re: Users permission to run DTS without being sysadmin

You can certainly do this yes. I would be inclined to add a user password to the package.

--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com




"Berimu" <Ivo.mulders@xxxxxx> wrote in message news:1169037097.343881.86280@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

We would like users to run DTS packages in a production without them
being sysadmin or owner of the package? Is this possible using
securitysettings and not a VB, .net interface?

Ivo

.

Relevant Pages

  • Saving pkgs when not the owner or sysadmin
    ... are not the owner of the package or a member of sysadmin? ... For instance I have a package that was created by another ... Neither of us are members of sysadmin. ...
    (microsoft.public.sqlserver.dts)
  • Re: Import multiple mdb files to SQL Server issue: Please Help...
    ... "Allan Mitchell" wrote: ... Doing the loop inside the loop is fine but will involve a lot of coding if ... DTSStep_DTSActiveScriptTask_3 to take the next mdb file then do the ... DTSStep_DTSActiveScriptTask_3 is not the same in your package. ...
    (microsoft.public.sqlserver.dts)
  • Re: remotely call a DTS
    ... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
    (microsoft.public.sqlserver.dts)
  • Re: Import multiple mdb files to SQL Server issue: Please Help...
    ... What is probably happening is that the step I mention DTSStep_DTSActiveScriptTask_3 is not the same in your package. ... "Allan Mitchell" wrote: ... I know the file extension .res doesn't look like MDB but it is. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL 2005, DTS, problems, problems, problems, etc..
    ... "Allan Mitchell" wrote: ... all columns mappings, and some of my tables have 50+ columns. ... I will be using the Execute 2000 Package task and leaving it at that. ... Backward compatibility/2000 DTS Components installed? ...
    (microsoft.public.sqlserver.dts)
Loading