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.
Timestamp Error
Moderators: chulett, rschirm, roy
Re: Timestamp Error
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.....Seya wrote: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.
RK