topic Re: Load csv file to sql server (without header) in Talend Studio

Load csv file to sql server (without header)

FSternberg — Fri, 15 Nov 2024 23:26:15 GMT

Hello,

I am implementing the same example of Talend "Using Dynamic Schema to load data dynamically to database tables" and as the link below.

The ONLY difference in my case is that my csv file is not have the Header. I tried to change the Header option in the tFileInputDelimited component to "0" but is not working. I don´t know if in the Mapp component I need to do change something.

The error log is indicating a problem in the line of the first record.

https://help.talend.com/r/36FNvH4mND6uL3cKKzTU~w/dwdwubfJ4UuVuEon16ScjQ

I appreciate by help.

Re: Load csv file to sql server (without header)

Anonymous — Wed, 08 Dec 2021 01:24:45 GMT

Hi @Felipe Sternberg,

I was looking at one of your other posts on the dynamic schema the other day and realised that I had written a blog that *may* help or give you some ideas. Unfortunately I couldn't find it the other day. However, seeing this post I decided to look for it again.

This isn't a direct answer to your question here, but it shows you how the dynamic schema can be manipulated with a little code to get some extra functionality out of it. I *think* it might help here.

https://dzone.com/articles/migrate-data-between-databases-with-on-job-using-t

Regards

Richard

Re: Load csv file to sql server (without header)

FSternberg — Wed, 22 Dec 2021 10:00:14 GMT

hello I need read from csv file as input, the same of the example, it is working but not for more than one file at the same time. I need only know how the job could read more than one file in the directory and insert for sql.