Does anyone know how to use a DTS package to schedule a
stored procedure?

I am using SQL server 7.0.

All I want is my stored procedure to run at a scheduled
time, I am not concerned if I dont have use a DTS package
for that.

You don't need to use DTS to do this. To schedule anything is SQL Server you
use the SQL Server Agent. In Enterprise Manager expand the nodes down to
Management, SQL Server Agent, Jobs. From here you can add a new job with a
step type of TSQL. Just add the stored procedure call in here.


--
Darren Green
http://www.sqldts.com

"Nurul Alam" <nalam (AT) btinternet (DOT) com> wrote