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 |
|
whizsql
Starting Member
17 Posts |
 Posted - 2009-01-12 : 14:50:54
|
| Hi,I have a SSIS import export package, which performs nightly refresh of around 100 tables on destination database.I wanted to perform custom logging around this import export package. Since, I am not familar with SQL 2005 as such, I dropped the plan & configured default logging process which logs information to sysdtslog90.Our DBAs are insisting on purging this table bi-weekly.Could you please guide me to set this task as part of SSIS import export package I created already. I dont know where to start infact.Thanks ! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-01-12 : 15:30:04
|
In Visual Studio.Be sure no task is marked.In Menu on the top of the screen click SSIS - there you will find it.Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
purging sysdtslog90 table in SSIS