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