Error Handling in DTS Package - Overwrite log file?

#1

Hello

I'm trying to perform package-level error handling within DTS. I would like to generate a log file when an error occurs within the package. I have been successful doing so, but do not like the fact that each time the package runs the file is appended to rather than being overwritten. Is there any way that I can overwrite the file rather than appending to it? Any ideas? Suggestions

Thank
Kevin

#2

In message <6C286195-A988-4965-9C35-AE798CAE16B6 (AT) microsoft (DOT) com>,
ktgillen <anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

Hello,

I'm trying to perform package-level error handling within DTS. I would
like to generate a log file when an error occurs within the package. I
have been successful doing so, but do not like the fact that each time
the package runs the file is appended to rather than being overwritten.
there any way that I can overwrite the file rather than appending to
it? Any ideas? Suggestions?

Quote:

Thanks
Kevin

How can I overwrite the package log for each execution
(http://www.sqldts.com/default.aspx?240)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Error Handling in DTS Package - Overwrite log file?

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

Error Handling in DTS Package - Overwrite log file? - 04-22-2004 , 09:41 AM

Re: Error Handling in DTS Package - Overwrite log file? - 04-22-2004 , 11:54 AM