Loading Fixed Width File using Teradata SQL Import

Database
Enthusiast

Loading Fixed Width File using Teradata SQL Import


I have a table with 50 columns. The Source File is Fixed Width File and I have to load that source using Teradata SQL Import.

Where should I select "Fixed Width" while importing and How should I write the query?

I have written query like this

INSERT INTO <TABLE NAME> (COL1,COL2....COLn) VALUES(?,?,?...?);

But it is saying "Wrong number of data values in input"

I have to use SQL Import only to do this task.

Thanks in advance!!!