473,395 Members | 1,527 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

About dtsrun

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
Nov 23 '05 #1
1 2284
DTSRUN is a command-line utility so you execute it from the command-prompt
instead of Query Analyzer. If your requirement is to execute the package on
the SQL Server instead of the client, you can run DTSRUN from a SQL Agent
job CmdExec step. It is also possible to execute command-line utilities
like DTSRUN from Transact-SQL using xp_cmdshell but the SQL Agent job is
generally preferred.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Kevin" <hu*@lucent.com> wrote in message
news:dl********@netnews.net.lucent.com...
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
Nov 23 '05 #2

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

Similar topics

1
by: Adam Augusta | last post by:
In a Multi Server Job under SQL Server Agent (MSX), we have a series of steps like: DTSRun /~Z0x8E8635E6BBA... The ~Z means it's an encrypted hexidecimal string. The person who created this...
1
by: JimA | last post by:
I have an application that needs to execute dtsrun from a remote machine. Basically I have a batch file on the remote box, which handles the execute. This works fine on a machine with client tools...
1
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...
0
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 =...
1
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...
5
by: mike | last post by:
I have a question. I am doing some work for someone and I have a batch file that they can run that will execute an OSQL line and a DTSRUN line. In both lines I run them using the /S /U /P...
5
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...
0
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...
0
by: David Greenberg | last post by:
Hi 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...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
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,...
0
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...

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.