Post reply

Basic differnce between Jobs and DTS packages

  • August 1, 2005 at 2:35 am

    #165535

     

    Hello friends

    Can any body tell me what is basic differnce between Jobs and DTS packages

    Can we run jobs by DTS or viceversa

    T.I.A

    Shashank

    Regards,

    Papillon

  • August 1, 2005 at 4:23 am

    #578457

    DTS packages are things that you have created to do a specific job on a server(s).

    Jobs are generally used to start the DTS package running at a certain time (and lots of other things), where this explanation falls down is that you can use a DTS package to start a job which allows you an extra amount of control for some tasks.

    Look at it this way, if you had a DTS package you wanted to run at midnight then you'd schedule a job to do it, this DTS package could start other jobs but without the initial one you'd have to be there to start it manually.

    Hope this helps explain it a little

  • August 1, 2005 at 9:36 am

    #578582

    Two complete different things!

    DTS was designed specifically to import or export data in and out of SQL Server.

    Jobs will run packages of DTS, or stored procedures, or code, on a schedule.

     

  • August 1, 2005 at 10:16 am

    #578605

    We're talking apples and oranges here..

    DTS allows you to make custom tasks(sql or activex) that you can schedule as a Job.

    DTS-- Data Transformation Services(theres a lot more than data trasformation you can do)

    Job-- Tasks that are scheduled

    HTH

  • August 2, 2005 at 1:02 am

    #578732

    hello friends

    Thanks , i got the point

    shashank

     

    Regards,

    Papillon

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply