Hi,

Here is my problem. I have created some stored procedure. In them I do
some print in order to know what the stored proc does. Now I execute
my sp with DTS. How can I get these 'print' in DTS?
I is quite important for me for debugging matter.

Thanks a lot

Lydie

The PRINT output will probably show up in the job history, but then it may
not, as DTS itself outputs a lot of status information.

A reliable way might be to write the status information to a text file using
DTS, or to a table in your database.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm


"lydie" <lsoler (AT) caramail (DOT) com> wrote

Hi,

Here is my problem. I have created some stored procedure. In them I do
some print in order to know what the stored proc does. Now I execute
my sp with DTS. How can I get these 'print' in DTS?
I is quite important for me for debugging matter.

Thanks a lot

Lydie

Thanks for your reply.
My PRINT output doesn't show up in the job history: I only get the DTS
status information.
Writing to a text file is exactly what I want to do. Do you know a
simple way?
Thanks again
Lydie

"Narayana Vyas Kondreddi" <answer_me (AT) hotmail (DOT) com> wrote