Hi,

We are trying to schedule a DTS Pasckage....
When we gave DTSRUN /S (our server name) /N (our package name) , we are
getting the error as " Incorrect syntax near '/' ".
We are using SQL server 2000 and windows authentication.
What is the command do we have to use for this case ?

Thanks

I always use

DTSRUN /E /SMyServer /NMyPackage


--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Test" <generalofmine (AT) yahoo (DOT) com> wrote

If your package name has spaces in it, try enclosing it in quotes as shown

DTSRUN /S ServerName /N "Package Name" /E

In message <uO0nurX1DHA.2528 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Test
<generalofmine (AT) yahoo (DOT) com> writes
If you want help with the dtsrun command line syntax, try the DTSRUNUI
tool. Just type DTSRUNUI in the Windows Run command box. Select the
server and package options, and then click Advanced. Now use the command
line generation option available. Note that you can remove the optional
parameters in the generated command line, but as a start point is
guaranteed to work.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Try running dtsrunui(user interface for dtsrun), then
choose advanced options and click the bottom option. A
command line will be generated and should give you an
idea of the syntax for what you need to do.