DSXchange

Posted: **Wed Aug 19, 2009 7:50 am**

Ray

There are no database triggers present.

Regards
Sreeni

Posted: **Thu Aug 20, 2009 1:53 am**

Hi All,

Any ideas how to resolve this ?

Regards
Sreeni

Posted: **Thu Aug 20, 2009 2:22 am**

Did you do this?

Sainath.Srinivasan wrote:Try creating a dummy table with 2 columns - varchar and datetime.

Pass same value (after typecast) to both and check the result.

Also run an sql insert via SQL Server front-end rather than DataStage to verify the outcome.

Posted: **Thu Aug 20, 2009 7:25 am**

Unfortunately, from what you've told us so far, your problem doesn't make much sense so we're pretty much out of ideas. I'd suggest you involve your official support provider and see if they can figure it out.

DSXchange

Data Mismatch using ODBC connector stage