SSIS Error (Union All + Data Conversion)

Chloe Wong
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.

  1. Check your data types, make sure that the Union All input data types are the same
  2. Drag and open Union All
  3. Delete the whole table (they automatically show every output columns and union columns)
  4. Re-write the columns’ name and map the union columns
  5. Click OK

This issue should be solved :)

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

--

--

No responses yet

Write a response