SSIS Fix: Validation error. The metadata for input column “…..” does not match the metadata for the associated output column.

 

After a schema change in the database I got the error: The metadata for input column “…..” does not match the metadata for the associated output column, on a Union all data flow transformation. To fix this problem:

Right click the "Union All"  > Edit…

Change the "Union All Input 2" value for the specific column to <ignore>:

image

 

Click on OK

Save package

Right click again on the "Union All"  > Edit…

Change the "Union All Input 2" value for the specific column to the correct value:

Click on OK

Save package

The error should be fixed.

Leave a Reply

Your email address will not be published. Required fields are marked *

2 comments

  1. ScottyJ says:

    This didn’t quite work for me. Instead I right-clicked the row and Selected Delete. Saved. Then re added the row.

  2. Tomasz Wieczorkowski says:

    Another solution is to:

    1. Open Union All
    2. Remember the names and delete whole row with issue.
    3. Click OK
    4. Open the Union All again
    5. At the end enter the deleted name back and select columns in Union Inputs 1,2 … as previously
    6. Click OK