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.
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