Text to character varying data type in PosgreSql

More
6 months 3 days ago #14685 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
6 months 3 days ago - 6 months 3 days 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.
 

HTH
Attachments:
Last edit: 6 months 3 days ago by admin.

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

Time to create page: 0.117 seconds
Powered by Kunena Forum