Timestamp Error

[Seya]

Hi,

The Design of Job is as follows:
ODBC STAGE(SQL Server)------> Transformer -------> OCI STAGE

I am try to read a timestamp column from ODBC stage and write the same OCI stage which is also a timestamp column, but when i try to do this i am getting the following error:

Oracle_Enterprise_0: Column COL2 has an unsupported type.

[g_rkrish]

Hi,

The Design of Job is as follows:
ODBC STAGE(SQL Server)------> Transformer -------> OCI STAGE

I am try to read a timestamp column from ODBC stage and write the same OCI stage which is also a timestamp column, but when i try to do this i am getting the following error:

Oracle_Enterprise_0: Column COL2 has an unsupported type.

did you check the format of Oracle timestamp with the SQl Server.....it might be different so you might need to do some changes in the format of timestamp.....