ERRORE: errorCode=-1073451000: The package contains two objects with the duplicate name of "output column "ErrorCode" (180)" and "output column "ErrorCode" (13)"

ERRORE: errorCode=-1073451000: The package contains two objects with the duplicate name of "output column "ErrorCode" (180)" and "output column "ErrorCode" (13)" by CHM.SQL

Resolved

as Won't Fix Help for as Won't Fix

Type:	Bug
ID:	336629
Opened:	4/2/2008 4:05:16 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

I can't make a copy of my SQL 2000 database in SQL 2005 using Import/Export Wizard 2005. I got the title error. I now to have a table with a column named "ErrorCode" but i can change structure (i must change application too). Alias to column do not workaround problem. I try using Copy database, but i get an error. How to do ? Thanks.

Details (expand)

Italian

SQL Server 2005 SP2 - Standard Edition

Integration Services (DTS)

Win2003 Standard Server (SP2)

Italian

Creating a table with a column named "ErrorCode" and using Import/Export Data to move to another database.

Any

To use the wizard to make a copy of database 2000 on a sqlserver 2005 (sp and view too).

0 attachments

Posted by Microsoft on 4/4/2008 at 3:12 PM

Thank you for your feedback and support of the SSIS product. This issue doesn’t currently meet the requirements for correction in SQL 2008. If you would like for us to consider this issue for correction after SQL 2008 RTM, please re-open or add your vote.

Again we appreciate your time and support.

Posted by Microsoft on 4/4/2008 at 3:16 PM

We have the workaound for your situation. Can you pelase try saving the package, and modify the package and then re-execute the package? With this steps, you should be able to meet your needs.

We hope this helps.

Posted by Schordia on 1/12/2010 at 4:56 AM

Upon saving the SSIS package generated by the improt/export wizard, it saves only the parent package which calls "innerpackage.dtsx", which is apparently not saved. hence cannot modify! any worksround or forcefull saving of the "innerpackage"?