EXECUTE a Stored Procedure with NO OUTPUT

  • I'm Executing a DTS Package in a Stored Procedure and it is PRINTING the OUTPUT from the execution.  The Stored Procedure is for a Report in Reporting Services.  Because of the Execution Output I'm not getting the actual dataset that I need for the report. 

    I'm feeling stupid to ask this but, what is the function or option setting so that there is no Execution Output?

     

  • I guess you are using the xp_cmdshell to execute the dts package from the procedure...

    use SET NOCOUNT ON also inside the proc...

    xp_cmdshell 'dtsrun /S... /E /N...',  no_output

    See BOL for details...

     

    MohammedU
    Microsoft SQL Server MVP

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

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