I fixed this issue by creating two different connection managers where I originally was using a single one for all the tasks described in the post, I created One straight...

Steve, thanks for your reply - SET NOCOUNT ON; is already enabled in all my stored procedures.