redirect output!

  • I'd like execute stored procedure inside the DTS Package and see all results from PRINT commands inside procedure. How I can see it or maybe there is someting like redirect output to file?

    Thank you in advance

  • I have a generic log table I created to write things like that to from within my procs. I go back after I finished working with it and remove the "debug" lines which write to my log. On procs that I need to see detail on often, I pass a switch as the last parameter, which makes it verbose (write to my log table). Of course, you have to set these things up in advance, and be consistent in its use, but it has always worked well for me.

    If your not gonna help, Please move to the side, because if your not helping the situation, your hurting it....

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply