DTS Steps not executing

  • I have a DTS package with a number of steps and it works fine when I execute it through EM.  However, if I try to run the package using DTSRun it stops executing after one of the steps.

    Any ideas?

     

    Jeremy

  • I've fixed this now by deleting each step and recreating it.  Not sure why this would fix the problem or why the problem appeared in the first place.

     

    Jeremy

  • Sometimes you can cure this by setting each step in the transformation to "Execute on Main Package Thread".  You do this by right clicking on the step and select "Workflow Properties".  Then select the options tab and check the execut on main pakage thread box.

     

    Ken

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

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