Text to character varying data type in PosgreSql

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


 

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