Invalid escape sequence csv to bdd

Highlighted
Four Stars

Invalid escape sequence csv to bdd

Hello,

 

I am trying to use talend open studio for data integration.

i have un csv file and i want to insert my data in a ms sql server data base.

 

but when i execute my job i have a error message.

 

i checked my csv file and it is okey.

but the app can't compile.

Can you help me please?

structure.PNG

error talend.PNG


Accepted Solutions
Moderator

Re: Invalid escape sequence csv to bdd

This can often happen when the details within the database output component are incorrect. Double check to see if the details entered are in fact the correct ones. 

View solution in original post


All Replies
Eight Stars

Re: Invalid escape sequence csv to bdd

Hello,

Can you please upload the CSV file?

Regards
lojdr
Moderator

Re: Invalid escape sequence csv to bdd

This can often happen when the details within the database output component are incorrect. Double check to see if the details entered are in fact the correct ones. 

View solution in original post

Four Stars

Re: Invalid escape sequence csv to bdd

you can found here the csv file, how i am using

Four Stars

Re: Invalid escape sequence csv to bdd

yes i resolve the problem here. i replace "\" with "\\" in the server name.

thank you for your helping

2019 GARTNER 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

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog