Hello together. When I try to preview/import a view (table) from MS SQL server I get the message:
Microsoft SQL Server - Connector:
ERROR [22007] Conversion failed when converting date and/or time from character string.,
If I load the same view from Google BigQuery (import from MS SQL) or by using the ODBC connector instead of the Qlik Microsoft SQL Server connector it's working correctly.
When I load not the view but rather the source table from SQL server its also working without any errors.
I can't see any differences between the definitions of date/time fields in the table and the view. So which options do I have to investigate/understand this behavior?
In history loading from Microsoft SQL Server connector was quiet faster than through ODBC connector.
