Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

EXECUTE a Stored Procedure with NO OUTPUT Expand / Collapse
Author
Message
Posted Friday, December 15, 2006 8:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 23, 2009 5:41 PM
Points: 1, Visits: 2

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?

 

Post #330872
Posted Friday, December 15, 2006 1:14 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 12, 2014 12:05 PM
Points: 1,190, Visits: 601

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
Post #330971
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse