Michael:

Thanks for your explanation

I used that code to demonstrate the behavior of xp_cmdshell in SSIS, but I'm not using that particular structure in my...

The weird thing to me is that by creating a temp table #temp in my SP and inserting the command output into it, it makes the problem go away.

INSERT

Just to follow up the above post. I reduced the SP to:

------------------------------------------------

CREATE PROCEDURE

 [dbo]