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

Five Stars

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

Hi everybody Smiley Very Happy ,

 

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

 

pic1.pngpic2.png

Five Stars

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

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 Smiley Wink

Gaviota

Employee

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

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download