Below is the error generated while trying to generate SSIS packages.
Component OLE DB Source of type AstOleDbSourceNode in Dataflow Export Source and Load Staging Table has duplicate column reference with name 'ErrorCode' on ouput 'Error'. This may be due to the 'ErrorCode' and 'ErrorColumn' columns that are automatically added to error output paths by SSIS. Ensure that all column names are unique.
The source in the dataflow task has a column name ErrorCode. How can I workaround this issue?
Regards