Post reply

DTS not running steps

  • December 15, 2006 at 4:26 pm

    #69167

    I have a DTS package, that runs each step individually just fine, but when I tell it to execute the package it just executes the first step, and tells me the whole package ran successfully.

    I'm pretty new to DTS, so it is probably something very simple, but I can't figure it out.

    thanks in advance

  • December 15, 2006 at 11:46 pm

    #678508

    What do you mean by step?

    Did you add the precedence in your dts package between your tasks?

     

    MohammedU
    Microsoft SQL Server MVP

  • December 16, 2006 at 10:23 am

    #678519

    I think that was Enterprise Manager's actual terminology.

    I have four 'things' that the DTS package does:

    1. Deletes data from two tables

    2. repopulates one table using a text file (transformation)

    3. repopulates the other table using an Excel file (transformation)

    4. runs a stored procedure

    I put precedence between the steps to run in the order described above, but it's only running the first step (deleting data) and then it stops and says the whole package was successful.

  • December 16, 2006 at 10:38 am

    #678520

    Run the profiler to check exactly what is happening...

    There might be no rows in the text file or your db connection might be configured to different server?

     

    MohammedU
    Microsoft SQL Server MVP

  • December 17, 2006 at 1:24 pm

    #678555

    I don't know what I did, really, but it's working now. I just went back and double-checked my precedences, which I think were fine, and when I ran it again, it executed all the steps. I am puzzled as to what exactly happened, but I'm also glad that it is working now.

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

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