Re: Does it require sa to create dts package?

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 12:19:35 -0700

By default, anyone with a login can create a Package as the
public role has execute permissions on sp_add_dtspackage
stored procedure in msdb and the guest account is enabled in
msdb by default so it depends on whether you have changed
this or not.
But they don't need to be a sysadmin to create packages.
It's generally controlled through sp_add_dtspackage.

-Sue

On Thu, 24 Feb 2005 09:35:07 -0800, "sabby"
<sabby@discussions.microsoft.com> wrote:

>what privilege does the user has to have to create a dts package?

Relevant Pages

  • Re: Permission necessary for a normal user to create and run DTS? Thanks.
    ... public role has execute permissions on sp_add_dtspackage ... stored procedure in msdb and the guest account is enabled in ... msdb so it depends on whether you have changed this or not. ...
    (microsoft.public.sqlserver.server)
  • Re: Use bind variables in a view
    ... >Is to basically wrap the view creation with a stored procedure, ... - define the variables in the package spec ... Alternatively (courtesy of Tom Kyte) you could set up a context, ...
    (comp.databases.oracle.server)
  • Re: How to force a SSIS package step to fail?
    ... I've now tried to add an Expression to the Precedence Constraints, bit I have some troubles defining the Varible it's going to look at..:-(. ... My Stored Procedure returns a character value, but when I set the step to return the value to the type String, then I get an "String: the Size property has an invalid size of 0" error everytime I execute the task. ... Why would you want the package to fail? ... could "fail" steps in order to control package flow, ...
    (microsoft.public.sqlserver.dts)
  • 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: I just want to run a stored procedure...
    ... I have a stored procedure that I want to run.The shell of it is ... PROCEDURE CODE0 (pCUR1 OUT CUR, ... You can't run a package, only the procedures and functions within it: ... I guess I just need to declare one? ...
    (comp.databases.oracle.server)