December 19, 2007 at 9:11 pm
Hi,
I have created an DTS and called an Stored Procedure from the DTS.
I can also call the Stored procedure from Jobs directly. What is the difference and which is the better way?
December 19, 2007 at 10:48 pm
Here's what I can think of:
With DTS you can have better logging and error handling.
Without DTS you don't have to have the DTSExec running in the middle which I have to believe consumes some CPU usage.
If it's something simple that will never be added to or need other tasks involved, I'd probably just go the SQL Agent only route.
December 20, 2007 at 6:59 am
To add to David...
With DTS you could deploy this to run from a workstation or other location (watch file paths) and distribute the load. It does not need to run from SQL Agent.
You can process the results of the stored prod to some extent.
Neither is right or wrong, both are options. If I'm doing other stuff, I might stick with DTS. I'd never create a DTS package just to run a proc. I'd just run it in the job step.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply