Load 03 different csv files into 03 different sql tables

FSternberg — Fri, 15 Nov 2024 23:30:02 GMT

Hello all,

Please, I want to import 03 differents csv files into an 03 different SQL tables like this:

file1 (id, name, price area) table= file1 (id, name, price, area)

file2 (cod, city, county) table= file2 (cod, city, county)

file3 (name, age, state) table= file3 (name, age, state)

How can I import all these csv files for these 03 existing different tables in SQL?

Doing only one csv file to one sql table I got to do but different tables no.

Any suggestions would be very appreciated!

Re: Load 03 different csv files into 03 different sql tables

Anonymous — Fri, 03 Dec 2021 10:16:26 GMT

Create different subjob for mapping each file and its corresponding table, eg:

tFileInputDelimited1--main--tDBOutput1 (for file 1)

|onsubjobok

tFileInputDelimited2--main--tDBOutput2 (for file 2)

|onsubjobok

tFileInputDelimited3--main--tDBOutput3 (for file 3)

Regards

Shong