DSXchange

Hi, We are in the process of ugrading from 7.5 to 9.1.2 and most jobs are running without issue. We have one job that is failing giving us a 'Metadata mismatch'. The SQL database table has the field defined as timestamp, scale 3. DataStage has the column defined as timestamp, scale 3. When the job runs I get the following

DWTempProduct1PIC..DWErrorLogPIC.OutDWErrorLogPIC: DSD.BCIOpenW results of function SQLColAttributes(MetaRunDate) gave MetaData mismatch
COLUMN.TYPE Expected = Timestamp Actual = Binary

DWTempProduct1PIC..DWErrorLogPIC.OutDWErrorLogPIC: DSD.BCIOpenW results of function SQLColAttributes(MetaRunDate) gave MetaData mismatch
MetaData mismatch on COLUMN.SCALE Expected = 3 Actual = 0

If I try to import the table definition, DataStage brings this field in as binary.

Any Suggestions are greatly appreciated.

Vinnie