topic ETL from Excel to SQL ... Help!!! in Talend Studio

ETL from Excel to SQL ... Help!!!

Anonymous — Mon, 13 Aug 2018 10:53:09 GMT

Hi everybody ,

I am trying to populate a table in SQL with data from Excel file.

So, the flux passed but my table in SQL is empty and a message is appeared (pictures at the bottom)

Thanks,

Gaviota

Re: ETL from Excel to SQL ... Help!!!

Anonymous — Mon, 13 Aug 2018 13:31:58 GMT

Hi Kaushik,

thank you very much for the information but I am not looking for an enterprise.

If I needed I will contact with you

Gaviota

Re: ETL from Excel to SQL ... Help!!!

Anonymous — Wed, 15 Aug 2018 08:21:32 GMT

Hi Gaviota,

Could you please verify whether the target column names in the tDBOutput schema are aligning to MSSQL naming standards?

Also please verify whether the schema specified in tDBOutput is matching to target table. If it is still not working, could you please share the screen shots of the tDBOutput and also the schema design window (input and output)?

Warm Regards,

Nikhil Thampi