Load 03 different csv files into 03 different sql tables

[FSternberg]

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!

[Anonymous]

Hi

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