topic Re: Error when importing data from csv into mssql server in Talend Studio

Error when importing data from csv into mssql server

Anonymous — Mon, 28 May 2018 06:20:49 GMT

Hi everybody,

I'm newbie on talend.

So, i've problem when importing data.

Does anyone knows why this issue can happen ?

Re: Error when importing data from csv into mssql server

Anonymous — Mon, 28 May 2018 06:57:02 GMT

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

Re: Error when importing data from csv into mssql server

Anonymous — Mon, 28 May 2018 07:27:37 GMT

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

Re: Error when importing data from csv into mssql server

Anonymous — Mon, 28 May 2018 08:05:47 GMT

Hi,

Really, Thank you

Re: Error when importing data from csv into mssql server

Anonymous — Mon, 28 May 2018 08:08:52 GMT

Hi Abhisek,

Thank you,

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

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

Re: Error when importing data from csv into mssql server

Anonymous — Mon, 28 May 2018 08:11:23 GMT

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

Best Regards,
Abhishek