Post reply

Process Not Ending

  • November 23, 2004 at 7:47 am

    #84269

    I am calling a stored procedure which runs a dts package.  The dts package imports a text file into a table.  The dts package runs fine when it is called from enterprise manager directly.  However, when I call the dts from the sp, the dts package again runs fine and completes its task, but the sp never finishes.  It just keeps on running. 

    Here is the sp:

    set  @retStatus = 99  -- reset return status

    Set @Cmd = 'dtsrun /S' + @@SERVERNAME + ' /E  /Nhr_KronosImport'  -- run DTS package

    execute @retStatus =  master..xp_cmdshell @Cmd 

    print  'return status'

    print @retStatus

     

    The print statement never executes

    Why won't the sp finish?  any help would be greatly appreciated

    Thanks!

     

  • November 23, 2004 at 8:23 am

    #531230

    Did you run the @Cmd in a cmd-box for test ?

    I guess it gives a popup at serverside

    once the popup has been replied your sp will go on.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • November 23, 2004 at 11:38 am

    #531266

    I ran this from a command window.  The dts package ran its last step but would not return to the command prompt.  The last message was:

    DTSRun = Package execution complete.

    A blinking cursor was on the next line.  The only way to return to the command prompt was to hit CTL+C.  There were no message boxes.

  • November 24, 2004 at 12:07 am

    #531341

    So there is the problem.

    I didn't encounter such a situation yet.

    What's the sql-version/sp / hf ?

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • November 24, 2004 at 8:01 am

    #531400

    This is a workaround but doesn't answer why it is sitting with the blinking cursor. Schedule the DTS package with any schedule. Open the job which is created and copy the command from the job text and execute this using xp_cmdshell.

  • November 24, 2004 at 9:13 am

    #531422

    I found the answer at

    http://support.microsoft.com/default.aspx?scid=kb;en-us;318819

    On the Workflow properties of the dts package, checking "Execute on main package thread" fixes the issue.  The package now runs and quits as it should.

    Thanks for all your help!

  • November 24, 2004 at 9:54 am

    #531437

    Thanks for the feedback.

    Glad you've solved it.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 7 posts - 1 through 6 (of 6 total)

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