Post reply

How to make DTS Start at a certain task.

  • April 12, 2012 at 12:40 pm

    #74310

    Greetings,

    I have a SQL2000 DTS package that populates an Access database.

    I have several "Execute SQL Tasks" that delete the data from the tables in the Access database.

    I then have several "Transform Data tasks" that populate the tables in the Access database with the latest data.

    I have On Success Precedence constraints between the "Execute SQL Tasks" in order to control the sequence of table deletions in the Access database.

    The problem I am having is the "Transform Data tasks" (Populating Data) appear to be running before or at the same time as the "Execute SQL Tasks" (Deleting of data).

    The end result is some Access tables are populated and others are not.

    I tried to correct the issue by rebuilding the package starting with creating the deletion tasks first and then add the population tasks last, but that did not help.

    I am at a loss as to what to do to fix this problem.

    Any and all help is appreciated.

    Thanks

    Gary

  • April 12, 2012 at 12:51 pm

    #1472887

    You need to add 'On Success' precedent constraint between the last Execute SQL task and the Transform Data tasks.

    Greg

  • April 19, 2012 at 11:56 pm

    #1476427

    Greg,

    thanks for pointing me in the right direction. I have several constraints but missed that one somehow.

    Gary

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

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