Reading CSV files with different schemas and writing to SQL server.

Hi,

I am new to FME, and I am trying to build an FME workspace that reads multiple .csv files from a folder and write each file to separate table in SQL server. Each CSV file:

• has different schema
• should became it is own SQL table

Here is what I tried so far:

1. I used Directory and File Pathnames reader
2. I used Feature Reader

The <Generic> port of Feature Reader shows no data, I am assuming because the schema of each is different. the <initiator> port give me the correct file name and path.