I'm struggline with the SSIS Execute SQL Task and wanted to see if it's me or
if it's SSIS 2005. I'm finding that I'm unable to add ReturnValue parameters
to the Execute SQL Task parameter list after already added the 0'th
parameter,e.g. initial syntax is

EXEC stored_proc ?, ? OUTPUT, ? OUTPUT...

I want to change it to EXEC ?=stored_proc ?,? OUTPUT, ? OUTPUT

I'm also finding that occaisionally that's also occuring with Output
Parameters. When I Create a new task and start from scratch it works...

Is there something I'm missing here?

--
Larry Barnes
BI Fellow, Avanade

Hello Larry,

Have you had a look at this article?

The ExecuteSQL Task
(http://www.sqlis.com/default.aspx?58)


Allan