Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
besadmin
Posting Yak Master
116 Posts |
 Posted - 2009-02-20 : 13:05:54
|
| Hey friends!!In need of serious assistance again.I have a stored proc using sp_OAmethod to execute a DTS job, in the DTS job The last step is xp_cmdshell deleting a file and it returns failure or success.I have a button that call the stored proc from a web page, so how do i return success or failure from the dts to the webpage or from the dts, back to the stored proc, and then back to the webpage.Thanks so much for any replys!Later, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-20 : 13:11:12
|
| one method is to use a log table and then after dts run, populate it with status of run (failure or success). then as next step, read the last inserted record from log table and use status value in webpage. you might need a audit column like dateadded in log table to get correct record. |
 |
|
|
besadmin
Posting Yak Master
116 Posts |
Posted - 2009-02-20 : 13:16:50
|
| cool, i am not familiar with that but i will look into how to use it.thanks a ton!Any other ideas still welcome as well!Thanks again! |
|
|
|
|
|
|
Return Value From DTS TO Stored Proc TO Web Page!