I get the following error message using the suggested code:
DataSource.Error: Microsoft SQL: Explicit conversion from data type int to date is not allowed.
Details:
DataSourceKind=SQL
DataSourcePath=sqlserver\orderwise;LiveData
Message=Explicit conversion from data type int to date is not allowed.
ErrorCode=-2146232060
Number=529
Class=16
What is DDL? How can I provide this and test data?