transfer task error

  • 24 March 2023
  • 5 replies


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 24 March 2023, 16:02

View original

5 replies

Userlevel 6
Badge +5

Hi @ebay in order to troubleshoot, do you have a dummy csv file similar to the one you are connecting to? Can you also please share the data source settings?

Userlevel 6
Badge +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.

Userlevel 6
Badge +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 @Christian Hauggaard . I will send you the csv file that I work on.