Getting: Error 0xc0047008 VS_ISCORRUPT

  • Getting errors below. All I am trying to do is copy a table from one DB (ona another server) to another DB.

    Error 0xc0047008: Data Flow Task: The package contains two objects with the duplicate name of "output column "ErrorCode" (13)" and "output column "ErrorCode" (126)".

    (SQL Server Import and Export Wizard)

    Error 0xc0047008: Data Flow Task: The package contains two objects with the duplicate name of "output column "ErrorColumn" (14)" and "output column "ErrorColumn" (129)".

    (SQL Server Import and Export Wizard)

    Error 0xc004706b: Data Flow Task: "component "Source - Cleanup2007" (1)" failed validation and returned validation status "VS_ISCORRUPT".

    (SQL Server Import and Export Wizard)

    What does "VS_ISCORRUPT" mean? Is Visual Studio Corrupt? The server are full SQL 2005 installs with SQL SP2 and Windows SP2.

  • I know this is a SQL Server 2005 related post, but when using the wizard for moving a database from SQL 2012 to SQL 2014 we received the same error. After doing some research, I found this:

    https://connect.microsoft.com/SQLServer/feedback/details/252471/ssis-errorcode-column-in-source-table-causes-duplicate-errorcode-to-be-introduced

    We found out that if you have a column in any of your tables named [ErrorCode] or [ErrorColumn] it will throw an error. We re-named the fields and everything ran fine. Apparently, this is a feature of the wizard.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply