dbTalk Databases Forums  

Sending 'print' output to dts log

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Sending 'print' output to dts log in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
aaronaw2k
 
Posts: n/a

Default Sending 'print' output to dts log - 12-15-2004 , 05:37 AM






Hi. I have a dts package that is saved as a structured storage file.
The package is executed via dtsrun and the logging is sent to a log
file. In my package are several SQL tasks. How could i send my SQL
print output to the dts log file? Much thanks!!


Aaron


Reply With Quote
  #2  
Old   
Ilya Margolin
 
Posts: n/a

Default Re: Sending 'print' output to dts log - 12-15-2004 , 08:11 AM






Aaron,

You cannot. The print output is sent to graphical interface only. One thing
you could do is to convert the print messages into table records or
recordsets and read them in ActiveX task writing them out to a file. I do
not think you can send them to dts log file.

Ilya

"aaronaw2k" <aaronaw2000 (AT) gmail (DOT) com> wrote

Quote:
Hi. I have a dts package that is saved as a structured storage file.
The package is executed via dtsrun and the logging is sent to a log
file. In my package are several SQL tasks. How could i send my SQL
print output to the dts log file? Much thanks!!


Aaron




Reply With Quote
  #3  
Old   
aaronaw2k
 
Posts: n/a

Default Re: Sending 'print' output to dts log - 12-15-2004 , 07:45 PM



Thanks for the info Ilya


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.