DSXchange

I am using a column EFF_DT timestamp ,microseconds length 27, and scale 7.In SQL Server it is defined as DATETIME2(7).When i ran the job i found the warning below and we should not have a single warning in our jobs as per rules.Please suggest a solution to eliminate this

"Schema reconciliation detected a size mismatch for column EFF_DT. When reading database column DATETIME(fraction=7) into column DATETIME(fraction=6), truncation, loss of precision or data corruption can occur."

I checked the General Post by Ray on ODBC connector stage but didnot suggest to comeout of the warning it only says fatal error can be converted to warning but how to eliminate this???

You can change from fatal to warning in the Connector stage itself, for size mismatch and data type mismatch. They are two separate properties.

ray.wurlod wrote:You can change from fatal to warning in the Connector stage itself, for size mismatch and data type mismatch. They are two separate properties. ...

The problem is we should not have warnings in the jobs.I understand in this situation I must use enterprise stage.

I also found the same warnings while using connector stage. The solution which I applied was- In director I added a message handler and demoted those warnings to info.

We cannot handle that warning since we will need to handle on test and production environments which is not accepted by our architects. Hence use Enterprise stage.