I am getting the following error in a straight move initial load job.
Code: Select all
ORA-01036: illegal variable name/number
I am using ODBC to pull the data as well to load the data. I AM NOT USING A CUSTOM SQL in this job. Also there is no lookup. The column names i am using also do not include any reserved word/words.I am getting this error when Ds is trying to execute the insert sql statement
Can anybody please help in debugging this error.
Thanks,
Ash.[/code]