While studying SQL Server's performance tuning concepts, I discovered that using SET NOCOUNT ON in the first line of a stored procedure and then setting it back to SET NOCOUNT OFF in the last line will assist to enhance performance.
How would that be useful when utilizing the stored procedure with an SSIS package, I wonder?