When reading datetime2 fields with tMSSqlInput, all the date values come as null.
I even specify the date pattern "yyyy-MM-dd HH:mm:ss.SSS" in the schema definition, but to no avail.
I have also tried the tMSSqlRow component and it produces the same results.
I would appreciate your help in fixing this issue.
Solved! Go to Solution.
Yes i'm using the Microsoft jdbc driver as required per the MSSqlInput component. There is data in the table that I'm querying, but it simply comes as null.
Another odd, perhaps unrelated, behaviour, is that when I press guess schema based on the query, Talend produces the following error "class not found net.sourceforge.jtds.jdbc.driver". Is there something wrong with the installation?
Edit: Using a jtds jdbc connection to the MsSqlServer fixes the datetime related issue.