MetaData mismatch

Bilwakunj · Post by **Bilwakunj** » Mon Sep 27, 2004 11:56 am

Hi,
I am trying to to do a simple job. source is sequential file having a single col. day in the format of (yyyy-mm-dd) . the details are:
SQL Type char
Length 10
Data Element Date.tag

Target is ODBC stage
SQL Type Data
Length 19
in the transformation , just mapped the column, no other operation is done.

At the time of running it's giving following error.

gave MetaData mismatch
COLUMN.TYPE Expected = Date Actual = Timestamp

Can anybody help me out ?

Thanks in advance.

kcbland · Post by **kcbland** » Mon Sep 27, 2004 12:27 pm

You need to import table definitions of your target and load it into the ODBC stage definition. You need to map the source data into the form the target will accept. If your ODBC target requires the date information in a specific form, you must manipulate the data into that form. If your target is SQL-Server, then put the date value into a timestamp form by concatenating time information to the date.

You need to make sure that you always use the target table definitions in the ODBC or OCI stages.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 27, 2004 4:17 pm

Search the forum for "metadata mismatch". It's warning you that what's in your job design doesn't match what's in the table. If you make them match (e.g. by editing your job design) the warning goes away.