"Paddy" <padmanabhanceg@gmail.com> wrote in message
news:1168716703.573539.285930@v45g2000cwv.googlegroups.com:

> I want to execute multiple Stored Procedures from a single Execute SQL
> Task, all of them being parameterized..
>
> EXEC usp_MySProc2 ?, ?, ?
>
> EXEC usp_MySProc2 ?, ?
>
> If i try this in the Properties pane of the Execute SQL task, SQL
> Server is reporting Invalid Parameter Number.. Is there any way to do
> this without having to create multiple Execute SQL tasks
>
> Thanx in Advance,
> Paddy