I want to run a DTS package and then a Stored Procedure in which i have to
pass tw0 Parameters...
How can i do this..??
separately i can run the DTS and Exec the Proc ...but how can we do this in
one command or single click of a mouse....
any one can come up with a good solution for this... using DTS Tasks or
anything is ok.....
xp_comdshell, sp_oamethod or sp_start_job...

Why wouldn't you just add an execute sql task as the last step in the
package and call the proc from there?