Create a SQL table and load a CSV file (CSV file without header line)

[PraveenM]

Hi,

I need to create a table in SQL server and then load a CSV data in to table (mapping in the order of position).

Task look simple, but I am struggling to do in both input / output tools and also "indb" tools.

Any help is great. Thank you.

regards,

Praveen

[Amarendra]

Hi @PraveenM 

I usually take my CSV's and then run them through a auto field tool. I then use a select to manually adjust data types and sizes. Once I am done, I use the In-DB tools for DB write back. Be sure to use "Data Stream In" tool and then the "Write Data In-DB" tool.

Is this what you did to begin with?