Error when importing data from csv into mssql server

Four Stars

Error when importing data from csv into mssql server

Hi everybody,


I'm newbie on talend.

So, i've problem when importing data.

 

Does anyone knows why this issue can happen ?

 

 


Accepted Solutions
Seven Stars

Re: Error when importing data from csv into mssql server

Hi,
You can refer the below flow -
tFileInputDelimited -> tMap -> tMSSQLOutput
Put the values of the credentials as expected by the individual components.

Best Regards,
Abhishek

All Replies
Five Stars

Re: Error when importing data from csv into mssql server

Hi,

 

Please check the for follwong things:

1. Please check the path of source CSV file
2. Check the schema of CSV file
3. Map source and destination scemas properly
4. Check tMSSqlOutput connection details
5. Check schema of output table

If error is still not resolved please attach the screenshot of your job.

 

Thanks,
Trupti

Seven Stars

Re: Error when importing data from csv into mssql server

Hi,
You can refer the below flow -
tFileInputDelimited -> tMap -> tMSSQLOutput
Put the values of the credentials as expected by the individual components.

Best Regards,
Abhishek
Four Stars

Re: Error when importing data from csv into mssql server

Hi,

Really, Thank you Smiley Happy
Four Stars

Re: Error when importing data from csv into mssql server

Hi Abhisek,

 

Thank you,

I've solved this problem. You right, I forgot to add tmap(component) before connecting to t..Output Smiley Happy

 

btw, do u have source to learn talend step by step ?

Seven Stars

Re: Error when importing data from csv into mssql server

Hi,
You can refer the Vikram Takkar tutorials and then Talend Open studio guide for the Data Integration.

Best Regards,
Abhishek

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

Downloads and Trials

Test drive Talend's enterprise products.

Downloads