July 16, 2013 at 5:04 am
We use a fairly detailed level of logging within our packages.
It's configured for each package by selecting the SSIS / Logging / Details / Advanced tab.
There is no obvious way to select StartTime and EndTime for every row which is logged - they appear to be mandatory.
OK, we can live with that. But we've noticed that, for every row, the values for StartTime and EndTime are identical. Our log table is currently 70 million rows in size, so that's not a small sample.
Do others see the same thing? Are these values ever different?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
July 16, 2013 at 5:39 am
Never really payed attention to it, but you're right. I just ran a package with every possible log event enabled, but the columns are still the same.
So you can basically ignore the endtime column.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2013 at 6:08 am
Koen Verbeeck (7/16/2013)
Never really payed attention to it, but you're right. I just ran a package with every possible log event enabled, but the columns are still the same.So you can basically ignore the endtime column.
Thanks for confirming that we are not alone - that's an awful lot of wasted disk space around the world.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply