How to load data from text file to table in odi 12c mapping?

I am trying to load data from text file to a table. The mapping executes successfully but no data is loaded to the staging table. I am using LKM FILE TO SQL and SQL Control Append as IKM. Staging table is created but not loading the rows to the table, insert rows is 0