Transferring CSV file to my data lab in Teradata

Teradata Studio

Transferring CSV file to my data lab in Teradata

Hi,

i am trying to transfer a CSV file to my data lab in Teradata. the file has 6 million rows. i have been getting an error saying unexpected Token. any idea how to fix the issue?

Teradata error.PNG

3 REPLIES
Teradata Employee

Re: Transferring CSV file to my data lab in Teradata

Unexpected token error comes when processing the input file, row by row, and finding unexpected column data. It can be that the File Option delimiters or line separator are set wrong or the data is bad, possibly the string delimiter?

Re: Transferring CSV file to my data lab in Teradata

Thanks. I know it's not the string delimiter. the file is huge and can't even open it in a text editor. any suggestion on how to check the file for errors?

Enthusiast

Re: Transferring CSV file to my data lab in Teradata

Did you created the target table before loading or are you table creating while loading.check the file layouts?