Created a simple job with tCreateTable,tFileInputDelimited,tmysqloutput
the table is created under database but no data is ingested. see the attached screen shot for error
@arun_mahi - I tried to re-pro your use case and it went pretty well for me. Did a tCreateTable and when that was successful read a delimited file and inserted those records into the created table using tMSSqlOutput (in my case).
Job Layout -
Looking at your error it looks like you might had missed some configurations for tFileInputDelimited. You need to check once for the setting carefully or else do share the screenshots for each of your components.