Post reply

Remove OUTPUT

  • August 3, 2005 at 2:34 pm

    #61181

    Here is my problem.  I am using dtsrun inside the sp.  when I execute the SP I get the output of the DTS package in the result window. 

    output                                                                                                                                                                                                                                                          -------------------------------------------------------------------------------------------------

    DTSRun:  Loading...

    DTSRun:  Executing...

    etc

    Is there any way I can get rid of it?  I only want for my SP to return either an error message or nothing. 

     

    thank you

  • August 3, 2005 at 2:58 pm

    #579366

    I just needed some coffee...

    I use xp_cmdshell to execute DTSrun.  So all I had to do is add no_output.

    Thank you

     

  • August 3, 2005 at 3:05 pm

    #579367

    Welcome to the club .

    Was wondering what the h3ll was hapenning there .

  • August 3, 2005 at 3:10 pm

    #579369

    very simple...lack of caffeine

    I will keep that in mind the next time when I have the urge to ask a silly question.

    thank you!

  • August 3, 2005 at 3:11 pm

    #579370

    Happy to have waited to try to help .

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

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