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 |
|
jdoering
Starting Member
32 Posts |
 Posted - 2002-09-19 : 18:03:58
|
| Hello All!I am running a DTS job from a stored procedure. When the stored procedure is complete, it returns the step by step status of the DTS job. Is there any way to suppress this? (I'm not referring to rowcount Set NOCount ON)Thanks,Julie |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-19 : 18:34:49
|
| If you're using xp_cmdshell to call dtsrun, you can include the no_output keyword to suppress it. See Books Online for more details on xp_cmdshell. If you're using another method, you'll have to provide more details. |
 |
|
|
jdoering
Starting Member
32 Posts |
Posted - 2002-09-19 : 19:01:32
|
| Thanks, that worked like a charm! |
|
|
|
|
|
|
Suppressing DTS run status in sp