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 |
|
Sqlraider
Yak Posting Veteran
65 Posts |
 Posted - 2011-02-14 : 13:56:18
|
I import many tables each night using a SSIS package. The package write about 6,000 records to the sysssislog each day. I do not need to keep this information more than 30 days old. I would like to know where to set the retention period for this package?This is what I found in BOL, but could not find where to set it:quote:
Log RetentionA collection set log is kept for the same length of time as the data in the management data warehouse is kept for the collection set. This is defined by the retention period that you can configure for each collection set. When the retention period expires, a SQL Server Agent job purges the data from the log.
Does anyone know where to set this?Thanks. |
|
|
|
|
|
sysssislog retention