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
View original
+5
Hi
+5
Also, what is the Row Scan Depth set to? Please try increasing this value and then running the sync and transfer tasks again
I send you the changes I made. I increased Row Scan from 0 to 105. But doesnt work.
+5
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?
Thanks
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
