Re: XML Log (-> file size!)
- From: "Frederik V" <vellemansf@xxxxxxxxxxx>
- Date: Mon, 20 Aug 2007 15:36:11 +0200
This is a good idea, I will discuss this with my team, thx for your help!
Kind regards,
Frederik
<jhofmeyr@xxxxxxxxxxxxxx> wrote in message
news:1187608098.280331.102610@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On 16 Aug, 14:27, "Frederik V" <vellema...@xxxxxxxxxxx> wrote:
Hi everyone,
I'm asked to continue an existing project in SSIS, which currently uses
XML
for logging. I noticed that we now have log files up to 200MB in size. Is
there a way to limit those log files in size?
Please do keep in mind that I'm still learning SSIS, so keep your answer
as
simple as possible :-)
Many thanks for any help!
Hi,
I tend to log to a new file every day - then size management becomes a
function of file archive policy.
There are a number of ways to implement logging in this way - my
preferred method is to set the ConnectionString property for the
logging file connection using an expression.
To do this:
1) Right-click on the connection in the connection manager and select
Properties.
2) Click on the Expressions property and open the Property Expressions
Editor.
3) Select "ConnectionString" from the Property drop-down and open the
Expression Builder.
4) Type in your filename expression (e.g. "C:\Logs\SSISLog_" + @date +
".xml")
If this isn't an option for you, you might want to review your logging
options. SSIS provides quite a detailed level of logging and it may
just be that you need to configure it to only log the information that
you need for support / reporting purposes.
Good Luck!
J
.
- References:
- XML Log (-> file size!)
- From: Frederik V
- Re: XML Log (-> file size!)
- From: jhofmeyr
- XML Log (-> file size!)
- Prev by Date: Re: Real challenge for DTS and Gurus
- Next by Date: Re: Strange error when Executing an SSIS package from a SQL Job
- Previous by thread: Re: XML Log (-> file size!)
- Next by thread: Re: XML Log (-> file size!)
- Index(es):
Relevant Pages
|
