Hi

I am really hoping someone will be able to help me with this one. I
want to manually enter a command in a SQL Job within SQL Server which
will run a DTS Package with parameters.

The reason is that my users are able to create scheduled jobs from a
web front end which will then run the DTS. The DTS is pre-created so I
already know what the name of it is.

Would anyone therefore be able to provide me with some tips and example
syntax that I should put within the step of my job?? I also need to
know which mode to run the command in eg. CmdExec or TSQL etc.

Any help would be hugely appreciated as Books Online and online help is
a bit thin.

Thanks

Dave

You can use dtsrunui.exe to see how the syntax is working. if you need to
pass global variables to the package, it will show you how to do this. Pick
your package in dtsrunui, and click the advanced button. In there you can
assign global variables and have the app auto generate the syntax for you -
that way you can get an understanding of the dtsrun command line options.

--
Simon Worth


<bungle (AT) wizardbuy (DOT) com> wrote

You could even use this

Getting Syntax Help for DTSRun
(http://www.sqldts.com/default.aspx?301)




"Simon Worth" <REMOVEFIRST_simon.worth (AT) gmail (DOT) com> wrote