on 07-19-2008 11:44 AM
Hi,
We are facing a peculiar issue in our zero date conversion. I do a date transformation of u201C00000000u201D to a constant date using the date trans function. During run time when the zero date is encountered it maps the correct constant date. But when we check the sql server DB, the date is created with an extra day. Eg: If we had set the constant date to 12/30/2005, the date in the sql server is 12/31/2005. But the XI mapping contains only 12/30/2005. Any ideas.
Teresa
HI
Why are you using a Date Transformation function, do one thng try using fixed value map and map if input is 00000000 to the date u want it to be.
Try this out.Also check if the Payload after mapping is has the right format and date which u want
In the JDBC reciver channel monitoring u can find it...
Rgds
Aditya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Not an XI issue. Check with the DB properties. Also try making an entry directly into the DB without XI. See if the problem persists.
Regards
Monika
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Any ideas..
Teresa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.