473,581 Members | 2,285 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

What privilege is needed to run DTSRUN ?

We use Sql 2000.
I have a user that I want to be able to run a bat file with the DTSRUN
command in it on a remote computer.
What happens now is that she runs the bat file , reads the DTSRUN
command but doesn't do anything with it and continues in the bat file.

What privilege do I need to give her so that she can run DTSRUN ?

Right now she has no server role and is defined with the database role
"public" for the database she needs to access.


Mar 19 '08 #1
0 1962

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Ping | last post by:
Hello, Have a wonderful new year! I have oracle 9.2 on XP. There is a table T1 created by user U1 in U1's schema, a synonym S1 created also by U1 to point to T1 in U1's schema, U1 granted S1 to public for select.
by: m3ckon | last post by:
Hi, I'm writing a stored procedure to run a dts package and I've successfuly got this working using my sotred proc and the syntax of dtsrun is correct. However, I'm trying to pass a variable to the DTSrun command and this is where I'm having the problem the code for the proc is:
by: José Joye | last post by:
I know, this kind of question has already been asked. However, I could not find an answer related to the minimal privilege required to be able to create a new event Source in the appplication event log. I have a service app that needs to access shares (therefore, I cannot not start it using the System account). This service needs not to be...
by: Daniel Reber | last post by:
I am trying to run a DTS package using C#. When I try to execute DTSRun it runs hidden, I do not see the command window anywhere. Here is my code: System.Diagnostics.ProcessStartInfo info = new System.Diagnostics.ProcessStartInfo(); //set up processstartinfo
by: Kevin | last post by:
when I run the following in sql Analyzer : dtsrun /S"Local" /Ntestemail /UExternalRO /P"changmail" got this error: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '/'. Is the command right?And how to run this dts package in commandline? Thanks
by: TaeHo Yoo | last post by:
Hi all, to run a DTS package you run dtsrun in the command prompt. It worked fine. But how to run dtsrun in c# console application? Thanks a lot *** Sent via Developersdex http://www.developersdex.com ***
by: lawrence k | last post by:
Okay, I just backed up my database, just in case. The whole schema for the database is here: http://www.accumulist.com/index.php?whatPage=db.php You can run any SELECT query against this database that you want, and send it as a GET request. This would be an example: ...
by: Brian Peasland | last post by:
I am trying to get a DTS package to be run from the command line with the dtsrun utility. The DTS package is stored in the database. The user I supply is a user in the database. I get an error stating "SQL Server does not exist or access denied." It looks to me like the SQL Server instance does exist because it tries to start the package. I...
by: dutdut | last post by:
Hello, With MS SQL Server 2000, to run a DTS package called « test » through a stored proc, I use : exec master..xp_cmdshell 'DTSRun /S (local) /E /N "test" /L "C:\Temp\log.txt"' When I execute this command with the query analyser, it runs perfectly. But in the stored proc, it fails… :( Actually, the dtsrun process appears in the...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.