Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2007-12-24 : 01:08:33
|
| Hi,I have a small requirement in SSIS Error Logging Mechanism. Presently in my SSIS package i am using a File Connection Manager for creating a Log file.I have a problem on this regard. Every time when i am executing my DTS package, the error log messages are getting appended to my error log at OS level (say D:\error_messg.log). And for this reason whenever my DTS package is getting executed the size of the file is keep on increasing and there by killing my disk space.I have a requirement for this error logging mechanism. At any time my log file should not exceed more than 20MB.Or can we remove the log events a week ago or say more than 2 days or say. Just ensuring the log file do not fill up the disk space eventually.How can we do this?Any suggestions are greatly appreciated.Thanks & Regards |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-25 : 08:46:09
|
| You can try to log to a new file every day. The method is to set the ConnectionString property for thelogging file connection using an expression.To do this:1) Right-click on the connection in the connection manager and selectProperties.2) Click on the Expressions property and open the Property ExpressionsEditor.3) Select "ConnectionString" from the Property drop-down and open theExpression Builder.4) Type in your filename expression (e.g. "C:\Logs\SSISLog_" + @date +".log")Set @date to SSIS package execution date |
 |
|
|
|
|
|
SSIS: Limiting Log File Size