<jhofmeyr@googlemail.com> wrote in message
news:1187608098.280331.102610@r34g2000hsd.googlegroups.com...
> On 16 Aug, 14:27, "Frederik V" <vellema...@delaware.be> 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
>

On 16 Aug, 14:27, "Frederik V" <vellema...@delaware.be> 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!

"Frederik V" <vellemansf@delaware.be> wrote in message
news:eFNgBlA4HHA.5212@TK2MSFTNGP04.phx.gbl...
> 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!
>
>
>