Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

DTS run syntax

Posted on 2008-10-16
3
Medium Priority
?
293 Views
Last Modified: 2012-06-21
This is saying incorrect syntax near '/'

Cant see what im missing ?
DTSRun /S "ServerA" /U "sa" /P "password" /N "DTS - Fusion - Create User"

Open in new window

0
Comment
Question by:mooriginal
  • 2
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 750 total points
ID: 22730666
I must assume that you try to run that as SQL statement, but it needs to be run as Dos Command statement.
0
 

Author Comment

by:mooriginal
ID: 22730748
this is being run from sql agent 2005 as cmd step

but im getting that error message and it looks fine to me
0
 

Author Comment

by:mooriginal
ID: 22730890
solved it
it wasnt running as cmd mode !
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question