user unable to execute a DTS Package

FAQ

Profile

user unable to execute a DTS Package

Database Forums (Home) -> DTS

Next: Migrating DTS to Integration Services

Author

Message

vardhansasi

External

Since: Feb 16, 2005
Posts: 1

(Msg. 1) Posted: Tue Oct 17, 2006 4:06 am Post subject: user unable to execute a DTS Package Archived from groups: microsoft>public>sqlserver>dts (more info?)

Hi, There is a package ' P' that is owned by a user "O"[Domain account with sysadmin/administrator rights]. Another user "U", who is not a sysadmin, but is db_owner of the DB that holds the Packages' objects, was not able to execute the package "P". Can anyone help "U" execute the Package with minimal permissions allotted?? like any permissions on msdb or so.... User "U" should only be able to execute the package but not edit it. Advance Thanks, Sasiraj. >> Stay informed about: user unable to execute a DTS Package

Display posts from previous:

Related Topics:

execute package of a number of execute package tasks - In a project I have created 6 dtsx packages, all doing about the same thing: sql task defines highest date in database and store in variable script task to create an oracle sql statement based on the above date dataflow task to 1.select from oracle...

Execute DTS package in SP - How would I execute DTS package in the SP? Thank you.

How to execute a DTS package from within Access 2000 - I want to know how to execute an existing SQL Server DTS package from within Microsoft Access 2000. Let's say I have an Access form with one control on it, a command button, and I want to execute the package when the button is clicked. Let's call my..

Execute SSIS Package - I re-created my DTS package in SQL Server 2005. I now execute the package using: [ Exec Master..xp_cmdshell 'DTExec /f C:\Data\packagename.dtsx' ] It is working fine however, is there another way of executing this package in SQL Server 2005 without..

Execute Remote DTS-Package on different Server - Hello DTS discussion group, i'm going crazy with one maybe simple problem on executing DTS on SQLSERVER 2000. Situation: I have in my local environment a DTS-Package, which starts another DTS- Package. I used both dtsrun as command line task and the..

	Database Forums (Home) -> DTS	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum