December 30, 2009 at 4:11 am
I have an SSIS package that writes to an XML log file whenever
there is a package error.
Is there a way of overwriting this log file each time the package is
run?
I am using the 'SSIS Log provider for xml files'.
Any help appreciated.
December 30, 2009 at 7:02 am
[font="Comic Sans MS"]
Hello Syamala
You have 2 options here:
1) Use expression to create files dynamically. That is new file for every different run or new file for everyday. You would need to append date/timestamp etc ..
You can refer here:
2) Create a separate package (say packageB) that will execute before the original package runs and create a filesystem task to move/delete the previous logfile.
Let me know how it goes or if you find any other solution 🙂
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply