DSXchange

I have a table to popluate and key ID field is a oracle sequence .
There is a trigger on the table to populate sequence ID.

When i try to populate the tabe using Oracle Enterprise , it is looking for ID field in the table regardless of me not mentioning the field in the columns.

It throws a error

Not writing to column ID, and the field does not accept nulls.

Any idea on how to resolve ?

I am using the same logic in server edition job and i have no issue populating the table.

Please share your thoughts.

What particular error message is thrown? It does no good to try to guess this.

you said ID is a column in the oracle table, then why don't you have that in your job to populate?