'SSIS - ORA-01722 - Invalid Number

I makeing simple SSIS dtsx pack where I select data from Sybase DB and I want to insert them to Oracle DB. Unfortunettly, I am getting ORA-01722 error code, but I cant figure out where I made a mistake.

First table (Sybase DB):

select * from d_agent

Data type for first table:

NUMERIC,NUMERIC,DECIMAL,VARCHAR,VARCHAR,VARCHAR,VARCHAR,VARCHAR,VARCHAR,VARCHAR,TIMESTAMP,INTEGER

Data that cant be inserted and error ORA-1722: 2,5005000,NULL,NULL,NULL,NULL,NULL,NULL,22436705,Test,Jun 30 2005, 96

Second table (Oracle DB):

ODBC Destination and right table selected copy.d_agent_sez

Data type for second table:

NUMBER,NUMBER,NUMBER,VARCHAR,VARCHAR,VARCHAR,VARCHAR,VARCHAR,VARCHAR,VARCHAR,DATE,NUMBER

SSIS error msg: [Transfer_ORACLE] Error: Open Database Connectivity (ODBC) error occurred. state: '22018'. Native Error Code: 1722. [Oracle][ODBC][Ora]ORA-01722: invalid number

What am I missing? Please help :) Thank you for help.

sqloraclessispythonhtmldjango


Solution 1:[1]

first of all, are you sure you really need a dict here? usually Django has a list of dicts. So, you loop just list, like here: https://github.com/ansys/aedt-testing/blob/cefebb91675dd54391d6324cd78e7bc97d9a8f6b/aedttest/static/templates/project-report.html#L220

however, answer to a direct question:

{% for key, value in data.items %}
    {{ key }}: {{ value }}
{% endfor %}

https://docs.djangoproject.com/en/dev/ref/templates/builtins/#for

Solution 2:[2]

use below instruction in template of django :

{{ key }}: {{ value }}

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Beliaev Maksim
Solution 2 Lawrence Gimenez

Related Questions