- Thank you received: 0
Text to character varying data type in PosgreSql
- phong.dangdinh
- Topic Author
- Offline
- User
-
Less
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
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.
- admin
- Offline
- Admin
-
Less
More
- Thank you received: 8
1 year 3 months ago - 1 year 3 months ago #14686
by admin
Replied by admin on topic Text to character varying data type in PosgreSql
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
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