Error when importing data from csv into mssql server

[Anonymous]

Hi everybody,

I'm newbie on talend.

So, i've problem when importing data.

Does anyone knows why this issue can happen ?

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

Hi,

Really, Thank you

[Anonymous]

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 ?

[Anonymous]

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

Best Regards,
Abhishek