Hi everyone
After successful synchronization of a csv file, I get an error in the transfer job. The error is: ‘The schema XXXData_CSV is invalid. Execution is canceled’
But with Query Tool I can see all of data. In addition If I click to preview this source in ODX , I take this error 'the sql server contains no data for the table'.
What changes should I make to the schema of this csv data?
Best Regards
Best answer by Christian Hauggaard
OK 0 is infinite so increasing that property will not help in this case. I recommend keeping it at zero, so that it scans all records before determining the data types.
Thanks for providing the data source settings. Do you have a dummy csv file (perhaps a subset of non-sensitive records) I can test with?
+5Hi
+5Also, what is the Row Scan Depth set to? Please try increasing this value and then running the sync and transfer tasks again
+5OK 0 is infinite so increasing that property will not help in this case. I recommend keeping it at zero, so that it scans all records before determining the data types.
Thanks for providing the data source settings. Do you have a dummy csv file (perhaps a subset of non-sensitive records) I can test with?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
