[resolved] Update / Insert data in MSSQL Server

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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