topic Re: Creating sql server tables using a file list in Talend Studio

Creating sql server tables using a file list

Mickael_Ro — Thu, 03 Apr 2025 13:54:15 GMT

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 !

Re: Creating sql server tables using a file list

marksouzacosta — Fri, 04 Apr 2025 14:25:01 GMT

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

Re: Creating sql server tables using a file list

Mickael_Ro — Fri, 04 Apr 2025 14:35:15 GMT

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.