Im trying to get the syntax right to run a DTS package from a stored procedure
a suggestion is to create a scheduled job and copy the code

where do i look for the job or the code in enterprise manager

sorry if im being a bit dim and thanks in advance
Earnie

You can follow the following article on this:
http://www.databasejournal.com/featu...le.php/1459181
To create a job and schedule the stored procedure in
Enterprise Manager, go to Management, SQL Server Agent and
Jobs. On the job node, right click and select new job.
Create a T-SQL job step to execute the stored procedure.

-Sue

On Tue, 8 Nov 2005 12:46:01 -0800, Earnie
<Earnie (AT) discussions (DOT) microsoft.com> wrote: