Tip: "TIME" fields, MyODBC and SSIS (Integration Services)

[Michael Robinson]

When you use the MyODBC connector to transfer a TIME field to Microsoft
SSIS (Integration Services), you get an 8-byte integer field whose
meaning is not at all obvious.  Have no fear... here's the mojo.

 

(1)     The time value is actually expressed in 100-nanosecond "ticks."


(2)     The right way to handle the value is in Visual Basic, using the
"Script" task, which gives you access to the "AddTicks" method.

(3)     Remember to check first whether the field IS NULL.