Post reply

Better to use Job or DTS

  • May 5, 2005 at 9:46 am

    #166755

    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

    #557151

    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.

  • May 6, 2005 at 1:31 am

    #557283

    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