Executing Stored Procedure after a DTS Executes

[Prabhat]

Hi All,

How Do I set a DTS so that after the DTS is executed - The DTS will Execute
a Stored procedure?

Or Which TASK I have to use for that and How Do I Set that?

Thanks
Prabhat

[scorpion53061]

You are in the wrong newsgroup....

However........

Open your DTS package in the designer and add a Execute SQL task.

In the SQL Statement window place

EXECUTE storedprocedure
GO

Tell the workflow to perform the task where you need it to be performed
at.

I've placed the proper newsgroup for this entry in the CC field.

"Prabhat" <no********@hotmail.com> wrote in message
news:OI**************@TK2MSFTNGP10.phx.gbl:

Hi All,

How Do I set a DTS so that after the DTS is executed - The DTS will
Execute
a Stored procedure?

Or Which TASK I have to use for that and How Do I Set that?

Thanks
Prabhat