May 5, 2005 at 9:46 am
I need to archive/move data on a daily basis from one instance to another. Whats better to use a DTS package running a stored proc or a job? Can anyone advise as to what the advantage of using DTS is in this case.
Thanks
May 5, 2005 at 10:28 am
No difference really. The job would run a stored proc of a DTS package, but the DTS could run your proc. If you have more than one task or want workflow, I'd look at DTS.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 6, 2005 at 1:31 am
Thanks alot Steve, think in this case I'll go with DTS as we do have workflow.
Have a good weekend
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply