Is it possible to create a DTS package to run several (75) stored
procedures.

If the answer is yes how do I set it up.

Thanks

Chris
North Cotswold Computing

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thanks

I'll look into that

Chris
North Cotswold Computing

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

If Stored Procs are your way forward and if you simply want to execute them
on a schedule then you do not need DTS. Whilst DTS does data movement, for
stuff like this you may be better using stright TSQL in a job step.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Chris" <anonymous (AT) devdex (DOT) com> wrote

The reason I want DTS to run the stored procedures is that I require
them to run after the tables have been cleared and the new data imported
all this is done by DTS and takes about 2 hours so I need to be able to
run these after all the data has been imported.

This is done each night

Chris
North Cotswold Computing

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

On Thu, 08 Apr 2004 08:05:03 -0700, Chris <anonymous (AT) devdex (DOT) com>
wrote:

You create the DTS package and add steps for each task you want to
execute. The text will be "EXEC spName" for each one. Click on the
first one, then the second one, and add a workflow step. Repeat until
you have a complete workflow from step one through step n. Save.
Run.