Creating sql server tables using a file list

[Mickael_Ro]

Hello,

I would like to retrieve the list of csv files in a local folder and create SQL Server tables automatically by name.

I use a “tFileList” component that retrieves file names. I then use a “tFileInputDelimited” component to retrieve the files.

But I get this error:

I think the problem lies with the “Main” link, which should be ‘iterate’, but this is not possible for a “tDBOutput” component.

Do you have an idea for my request?

Thanks !

[marksouzacosta]

Hi @Mickael_Ro,

First, you need your delimited file schema created in your Metadata based on your CSV file structure.
This will be the "recipe" to create your SQL Server Table.

Connect your tFileInputDelimited block to the tDbOutput block using the Row > Main.
Next, select the tDbOutput block, click on the Sync columns button to import the CSV schema to the tDbOutput Schema and on Table Action, select CREATE_IF_NOT_EXISTS. This will create the SQL Table during the process.

Regards,

Mark Costa

[Mickael_Ro]

Hello,
The problem isn't creating an sql table with a csv file. The problem is to automate the creation of sql server tables via a list of local csv files.