SSIS Error (Union All + Data Conversion)
1 min readJun 2, 2021
I received the following error message using Union All tool in SSIS after converting data type using data conversion.
TITLE: Microsoft Visual Studio — — — — — — — — — — — — — — — Error at LOAD Data Flow Task [Union All [695]]: The metadata for “Union All.Inputs[Union All Input 1].Columns[xxx]” does not match the metadata for the associated output column. Error at LOAD Data Flow Task [Union All [695]]: Failed to set property “OutputColumnLineageID” on “Union All.Inputs[Union All Input 1].Columns[xxx]”. — — — — — — — — — — — — — — — ADDITIONAL INFORMATION: Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap) — — — — — — — — — — — — — — — BUTTONS: OK — — — — — — — — — — — — — — —
To fix this issue, please follow the below steps.
- Check your data types, make sure that the Union All input data types are the same
- Drag and open Union All
- Delete the whole table (they automatically show every output columns and union columns)
- Re-write the columns’ name and map the union columns
- Click OK

This issue should be solved :)