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