I am currently using a Data Readers to load a cube to provide a count for Work Orders created based on a Date/Time field out of one of our SQL Tables. The Date Reader is rejecting half of the records due to a formatting error found in the Date/Time field.
Below is the current SQL query I am using to load the cube:
SELECT Convert(CHAR(22), dbo.work.datetime, 112), dbo.work.work, dbo.work.customer, 1
WHERE dbo.work.company = '36' and dbo.work.datetime >= '06/11/2018'
Is there a particular syntax required to format the Date/Time fields so that no records are rejected?
I have also attached a screen shot of the Date Reader results and an example of one of the Data Reader errors found in the XML Log.
Any assistance with is greatly appreciate.