posted 10/6/2011 by timmurphy - Views: [654]
I have a table with a column named ErrorCode. When I tried to use it in a data flow in SSIS I got this error:
[SSIS.Pipeline] Error: The package contains two objects with the duplicate name of "output column "ErrorCode" (2048)" and "output column "ErrorCode" (2285)".
The reason for this is because SSIS automatically creates a column named ErrorCode which is used for internal error handling. By right clicking the datasource and selecting Show Advanced Editor you can rename the SSIS generated ErrorCode column to something else and all is well. You can see I named it SSISErrorCode.
Also, you would also encounter this problem if you have a source column named ErrorColumn.
I don’t know renaming will affect Error Logging, but it worked in my case.