DSXchange

Hi:
I am sending the currenttimestamp() from the transformer to created_dt field , which is specified as Timestamp() in the meatadata.
I am getting the below warning message.Please advice me what conversion is required to rectify the below warning.


Dynamic_RDBMS_Load_Stage_tbl,0: Warning: DsRGW.Dynamic_RDBMS_Load_Stage_tbl: [DataDirect][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type nvarchar to data type timestamp, table 'WSO.dbo.TBL_WIRE_INFO_STAGING', column 'CREATED_DT'. Use the CONVERT function to run this query.

Thanks in advance
cnu

HI !!

Can anybody knows, advice me regarding the above warning.

Thanks
cnu

Cnu,

1)check whether the datatype for the created_dt column is a Timestamp or not
2) If you still get the same problem Try with convert functions in transformer
3) pass the timestamp directly

cnu wrote:Hi:
I am sending the currenttimestamp() from the transformer to created_dt field , which is specified as Timestamp() in the meatadata.
I am getting the below warning message.Please advice me what conversion is required to rectify the below warning.


Dynamic_RDBMS_Load_Stage_tbl,0: Warning: DsRGW.Dynamic_RDBMS_Load_Stage_tbl: [DataDirect][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type nvarchar to data type timestamp, table 'WSO.dbo.TBL_WIRE_INFO_STAGING', column 'CREATED_DT'. Use the CONVERT function to run this query.

Thanks in advance
cnu

Hi:
Yes,datatype for the created_dt column is a Timestamp .
I have passed the timestamp directly,getting the above warning.data is also not loading because of warning.
Please advice me which convert function can i use tr rectify.

Thanks
cnu

keep your target datatype as Timestamp but put a transformer before the DRS stage and use the below derivation

<Input Column Name>:(' 00:00:00.000')

In the Input Column name get the date in YYYY-MM-DD

Mahesh:

The column is not coming from source,i am assigining Timestamp() in the target side in the transformer.
The datatype in the target also Timestamp.
Its a simple i am not using any tranformation here,but giving warning.

Thanks
cnu