By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,882 Members | 928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,882 IT Pros & Developers. It's quick & easy.

Executing Stored Procedure after a DTS Executes

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.