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
Highlighted
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

View solution in original post


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

Highlighted
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

View solution in original post

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 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog