I am not seeing the issue. I have created a custom scheme, dictionary entry and a data source acquisition script in Perl. Tried to read the file content (same as mentioned below) and saved into a .CSV file. I was able to see the data in the SQL table.
Thank you all for the input. I have imported the file to Excel (had the file opened in Notepad++ and Wordpad) and run the function 'text-to-columns'. There is no TAB (`n) between each columns. I have to correct this.