On my Read CSV task, I have the time column defined as:
Code: Select all
<column index="7" name="TTIME" type="TIME" pattern="HH:mm:ss" trim="both" />
Code: Select all
<param index="7" type="NUMERIC" mapFrom="7" nullSubstitute="0" />
Thanks!
Code: Select all
<column index="7" name="TTIME" type="TIME" pattern="HH:mm:ss" trim="both" />
Code: Select all
<param index="7" type="NUMERIC" mapFrom="7" nullSubstitute="0" />