Timestamp in the Dynamic_RDBMS stage in Sql server database

[cnu]

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

[cnu]

HI !!

Can anybody knows, advice me regarding the above warning.

Thanks
cnu

[ray.wurlod]

Learn patience.

If anyone has anything to contribute, they will.

It's the middle of the night in the Americas.

[Nagasudheerkumar]

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

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

[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

[maheshsada]

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

[cnu]

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