main_program: Fatal Error: Added field has duplicate identifier(): CHG_TYPE_CD
There is no information as to which stage is causing this. I do not have RCP enabled in Administrator. Any tips on tracking it down?
I have only one lookup that I think could possibly be bringing in two columns of that name, and I have tried to avoid the CHG_TYPE_CD from coming in on the reference link by adding a Copy stage between the DataSet component and the Lookup stage and dropping the column in the Copy.
No, it's a runtime option and that environment variable should be one of the 'standard' ones that you add to every job. Then you can override it to enable it at any time should the need arise.
-craig
"You can never have too many knives" -- Logan Nine Fingers
We discovered the problem was that we had made changes to the table and had not imported the table definition since making these changes. Some of the changes were to the NULL/NOTNULL option of fields. We overwrote the table definition and tried it again but still got errors until we reloaded the columns. After reloading the columns into our stage, the error message disappeared!