topic [resolved] Update / Insert data in MSSQL Server in Talend Studio

[resolved] Update / Insert data in MSSQL Server

Anonymous — Tue, 23 Dec 2014 16:51:23 GMT

Hi,
I try to insert or update some datas in my MSSQL Server.
I have two Date, one for the insert, and the other for the update.
I check the use field option to user this.
But i have some errors.
Conversion failed when converting date and/or time from character string.
Conversion failed when converting date and/or time from character string.
Can you help me ?
Regards,
Yozol

Re: [resolved] Update / Insert data in MSSQL Server

Anonymous — Wed, 24 Dec 2014 07:10:04 GMT

Hi,

Conversion failed when converting date and/or time from character string

It seems your string data contains invalid date data
What's your input data datatype? "Date" or "DateTime"? Could you please show us your tMap setting screenshot?
Best regards
Sabrina

Re: [resolved] Update / Insert data in MSSQL Server

Anonymous — Mon, 29 Dec 2014 08:25:14 GMT

Hi,
Here a screenshot of my tmap,
Regards,
Yozol

Re: [resolved] Update / Insert data in MSSQL Server

Anonymous — Mon, 29 Dec 2014 09:18:52 GMT

Hi,
Did you set data type as "Date " or "DateTime" for your tMSSQLOutput schema setting?
Best regards
Sabrina

Re: [resolved] Update / Insert data in MSSQL Server

Anonymous — Mon, 29 Dec 2014 09:47:15 GMT

Hi,
It's DATETIME, but it change nothing if i select Date
Regards,
Yozol

Re: [resolved] Update / Insert data in MSSQL Server

Anonymous — Mon, 29 Dec 2014 09:58:40 GMT

Hi,
Could you please use tLogRow instead of tMSSQLOutput to see if there is any error printed on console?
tMSSQLInput-->tMap-->tLogrow
Best regards
Sabrina

Re: [resolved] Update / Insert data in MSSQL Server

Anonymous — Mon, 29 Dec 2014 10:01:31 GMT

Hi,
There is no error in the console
1||Billet simple CP||29-12-2014|29-12-2014|TEST
2||Billet simple expo||29-12-2014|29-12-2014|TEST
3||Billet jumelé||29-12-2014|29-12-2014|TEST
4||Forfait||29-12-2014|29-12-2014|TEST
Regards,
Yozol

Re: [resolved] Update / Insert data in MSSQL Server

Anonymous — Mon, 29 Dec 2014 10:10:16 GMT

Hi,
Have you tried to use option "Insert or Update" in tMSSQLOutput?
Best regards
Sabrina

Re: [resolved] Update / Insert data in MSSQL Server

Anonymous — Mon, 29 Dec 2014 10:14:58 GMT

Hi,
Same errors with "Insert or Update" in tMSSQLOutput.
Can it be a problem of Date Format "dd-MM-YYYY" instead of i don't know the format of DateTime but in my database datetime look like that : 2014-12-23 17:25:44.053
Regards,
Yozol

Re: [resolved] Update / Insert data in MSSQL Server

Anonymous — Mon, 29 Dec 2014 11:29:30 GMT

Hi,
When i uncheck the Use Field Options it works :
But i don't know why. Is there something to do for the Identy on insert ?
Regards,
Yozol

Re: [resolved] Update / Insert data in MSSQL Server

Anonymous — Tue, 30 Dec 2014 09:45:20 GMT

Hi,
It is probably caused by your data type. The data 2014-12-23 17:25:44.053 should be:yyyy-MM-dd HH:mm:ss.aaa.
Best regards
Sabrina