Post reply

DTS Package Steps and Tasks

  • February 3, 2006 at 4:14 am

    #152726

    Books Online states the following:

    A DTS package is an organized collection of connections, DTS tasks, DTS transformations, and workflow constraints assembled either with a DTS tool or programmatically and saved to Microsoft® SQL Server™, SQL Server 2000 Meta Data Services, a structured storage file, or a Microsoft Visual Basic® file.

    Each package contains one or more steps that are executed sequentially or in parallel when the package is run.

    My question is: Is there a difference between a step and a DTS task or are they synonymous? Please clarify. Thank you.

    Karim

     

     

  • February 3, 2006 at 4:43 am

    #618605

    Task objects are responsible for the work done in a package.

    A Step object is used to control a Task object. There is a one-to-one correlation between steps and tasks. For each task you have, you will have a corresponding step.

    Step will specify the order in which Task needs to run. 

  • February 3, 2006 at 4:51 am

    #618608

    Dear Rama,

    Do you mind explaining how a step object controls a task object? If there is a one-to-one corr. between task and step objects, then how can a single step object determine the order of the tasks in a package? Or do you mean to say that there are subtasks within a task object and a step controls the order in which these subtasks are executed? Please clarify.

    Thanks,

    Karim

Viewing 3 posts - 1 through 2 (of 2 total)

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