title: What is the advantage of using "Set NOCOUNT ON" in stored procedure's which are used in ssis packages?
body: <p>While I am going through the performance tuning concepts of SQL Server, I found  stored procedure using <code>SET NOCOUNT ON</code> in the initial line and again setting it back to <code>SET NOCOUNT OFF</code> on the final line will help to improve performance.</p>
  
  <p>My question here is: how will that be helpful while using the stored procedure with  a SSIS package?</p>