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
Timestamp in the Dynamic_RDBMS stage in Sql server database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Learn patience.
If anyone has anything to contribute, they will.
It's the middle of the night in the Americas.
If anyone has anything to contribute, they will.
It's the middle of the night in the Americas.
Last edited by ray.wurlod on Wed Aug 06, 2008 1:20 am, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 55
- Joined: Tue Apr 24, 2007 1:26 am
Re: Timestamp in the Dynamic_RDBMS stage in Sql server data
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
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
-
- Participant
- Posts: 69
- Joined: Tue Jan 18, 2005 12:15 am