Run DTS from SQL server jobs..

Hi is it possible to run multiple DTS from a SQL server
job? I tried the SQL enterprise manager wizard to build a
job but it does not allow me to select a DTS job. Am I
doing anything wrong?You can schedule multiple packages to run from one job. Manually edit the
job, and add as many Operating system command steps as there are DTS
pacakges to run. You can use the dtsrunui.exe to get the proper command
line using the advanced button in the user interface. It can generate the
command line for you, and you can copy paste it into the job step.
Simon Worth
"Yaheya Quazi" <yquazi@.ucmerced.edu> wrote in message
news:5c4501c52400$71c39450$a401280a@.phx.gbl...
> Hi is it possible to run multiple DTS from a SQL server
> job? I tried the SQL enterprise manager wizard to build a
> job but it does not allow me to select a DTS job. Am I
> doing anything wrong?|||See the post a few items down titled Calling a DTS job thru a Stored
Procedure. That would allow you to specify as many jobs as you like.
"Yaheya Quazi" wrote:

> Hi is it possible to run multiple DTS from a SQL server
> job? I tried the SQL enterprise manager wizard to build a
> job but it does not allow me to select a DTS job. Am I
> doing anything wrong?
>