Execute SQL Task

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

.

Relevant Pages

  • RE: Importing updated data in SQL2000
    ... Try to create a DTS by hand. ... aExecute SQL task to delete the data on your destination tables then ... gere as conexões e então faça uns execute sql que ...
    (microsoft.public.sqlserver.dts)
  • Re: Execute SQL problem with Oracle
    ... Apparently Oracle connection doesn't ... The 'Transform Data' task also works on the same Oracle ... What is unique about an 'Execute SQL' task that causes the ... >>go into properties of the Execute SQL task and click 'Build Query', ...
    (microsoft.public.sqlserver.dts)
  • Re: After Insert trigger copy rows to a file
    ... insert/update a simple 3 state Flag instead of a date field (which can ... at the top of your DTS you would attach a Simple Execute sql ... another Execute SQL task that updates this flag from 2 to 3. ...
    (microsoft.public.sqlserver.dts)
  • Re: Data Transform Task, how to delete rows in destination table
    ... Using execute sql task would be as safe as suing ActiveX or any other thing. ... > feature of the Data Transform Task, or possible use ActiveX in some ...
    (microsoft.public.sqlserver.dts)
  • Re: Execute Access VBA Macro from DTS
    ... You can use the "Execute SQL Task". ... Add an Execute SQL Task using the Access connection from step #1. ... "ricky" wrote: ...
    (microsoft.public.sqlserver.dts)