Text to character varying data type in PosgreSql

  • phong.dangdinh
  • Topic Author
  • Offline
  • User
  • User
More
1 year 3 months ago #14685 by phong.dangdinh
Text to character varying data type in PosgreSql was created by phong.dangdinh
Hi there,

I use SSIS to pull the data from PostgreSQL to PostgreSQL.
A problem occurs when a column in the source table has data type is TEXT and the column in the destination is character varying (50)

Error: 0xC0202009 at pos_crm_tran_data, OLE DB Destination [2]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E5C.
Error: 0xC00470BC at pos_crm_tran_data, OLE DB Destination [2]: The OLE DB provider failed during the data type conversion verification for "sale_id".
Error: 0xC0202009 at pos_crm_tran_data, OLE DB Destination [2]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E5C.
Error: 0xC00470BC at pos_crm_tran_data, OLE DB Destination [2]: The OLE DB provider failed during the data type conversion verification for "crm_identifier".
Error: 0xC0202009 at pos_crm_tran_data, OLE DB Destination [2]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E5C.
Error: 0xC00470BC at pos_crm_tran_data, OLE DB Destination [2]: The OLE DB provider failed during the data type conversion verification for "liquid_log_ref".
Error: 0xC0202009 at pos_crm_tran_data, OLE DB Destination [2]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E5C.
Error: 0xC00470BC at pos_crm_tran_data, OLE DB Destination [2]: The OLE DB provider failed during the data type conversion verification for "title".
Error: 0xC0202009 at pos_crm_tran_data, OLE DB Destination [2]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E5C.
Error: 0xC00470BC at pos_crm_tran_data, OLE DB Destination [2]: The OLE DB provider failed during the data type conversion verification for "rebated_by".

How I can fix this?

Many thanks,
Phong


 

Please Log in or Create an account to join the conversation.

More
1 year 3 months ago - 1 year 3 months ago #14686 by admin
Hi Phong,
these types of errors (failed during the data type conversion verification) can be resolved by using Data Conversion to convert the column to WSTR (or int to bigint, etc.), and remapping of the converted column in the Destination.
 

Attachment DataConvert.jpg not found



HTH
Last edit: 1 year 3 months ago by admin.
The following user(s) said Thank You: Mamyshev

Please Log in or Create an account to join the conversation.

Time to create page: 0.138 seconds
Powered by Kunena Forum