#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Lebanon, NH
    Posts
    2
    Rep Power
    0

    Automatic DTS Tutorial


    Hi, Does anyone know of a good tutorial on how to use the automatic dts? I want to have my database automatically download the new data every day late at night.

    Any tips?

    Thanks,
    Nick
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
    Do you mean scheduling a DTS package?
    There is really no need for a tutorial, just be sure that SQLServer Agent is up and running, build your DTS package and schedule it.
    Anyway a good source of info is www.sqldts.com

IMN logo majestic logo threadwatch logo seochat tools logo