SSIS Dates aren't very precise
I'm implementing some SSIS packages at the moment and
started looking at logging with the event handlers. I simply wanted task start
and end times etc and so used the start time system variables.
What I noticed when I ran reports was that the accuracy of these values is to
the second. When you've got a package that has sub second tasks thats not much
good.
So I created my own variable called Now and set it to
"EvaluateAsExpression" and set the expression to be GETDATE().
What this means is that when task uses this variable it is evaluated as the
current time and thus I get millisecond precision (or what ever the OS will give
me but thats another story).
Now I can easiliy see the order of my tasks precisely.
It all seems a bit easy to me so I am sure I have missed something
somewhere.
-