30 September, 2013
3 Comments
1 category
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>:
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.
Tags: SSIS
Category: Uncategorized
This didn’t quite work for me. Instead I right-clicked the row and Selected Delete. Saved. Then re added the row.
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
Thank you – this worked for me! A pain but thanks for providing the solution!!