Duplicate ErrorCode Columns in SSIS

If you are using SSIS to handle a column that has the name of ErrorCode you could run into an issue. You can find more information on the specifics @ Microsoft Connect.

Your error may look similar to this:
Validation error. Data Flow Task: DTS.Pipeline: The package contains two objects with the duplicate name of “output column “ErrorCode” (180)” and “output column “ErrorCode” (13)”.

In my case, here’s how I fixed it:
On the task(OLE DB Source) that gave me the error, I went into the advanced editor. Go to the “Input and Output Properties” tab and select the Error Output Columns. I simply changed the name of the second instance to ErrorCode2 and it worked for me. It may be better to actually rename your column in the table but that requires more work. I guess it’s possible that this could affect your error logging but for my case it did not.

,

  • Does your blog have a contact page? I’m having problems locating it but, I’d like to shoot you an e-mail. I’ve got some creative ideas for your blog you might be interested in hearing. Either way, great site and I look forward to seeing it improve over time.