Execute DTS from Job

How can I execute a DTS package from a Job using the
operating system command? Please help.Hello Vic!!
> How can I execute a DTS package from a Job using the
> operating system command? Please help.
You can use the command DTSRUN (you can find more details in books online
for TSQL)
or
try the program DTSRUNUI.EXE (you can find it in 80\Tools\Bin directory)
Bye!
Corrado

Execute batch file from a Job

How can I execute a batch file (upload.bat) from a Job.
I have the type of job as a Operating System Command, but
I don't know what to put on the Command box. I tried the
batch file path and file name, but it doesn't work.
Thanks,
Vicyou could try
cmd /c Your\Batch\File\Path\and\name.bat
"Vic" <vduran@.specpro-inc.com> wrote in message
news:03ec01c36055$3b8a9390$a501280a@.phx.gbl...
> How can I execute a batch file (upload.bat) from a Job.
> I have the type of job as a Operating System Command, but
> I don't know what to put on the Command box. I tried the
> batch file path and file name, but it doesn't work.
> Thanks,
> Vic|||Check out xp_cmdshell in BooksOnLine.
--
Andrew J. Kelly
SQL Server MVP
"Vic" <vduran@.specpro-inc.com> wrote in message
news:03ec01c36055$3b8a9390$a501280a@.phx.gbl...
> How can I execute a batch file (upload.bat) from a Job.
> I have the type of job as a Operating System Command, but
> I don't know what to put on the Command box. I tried the
> batch file path and file name, but it doesn't work.
> Thanks,
> Vic