'How do i solve this SISS thing?

TITLE: Microsoft Visual Studio

Error at Data Flow Task [Union All [303]]: The metadata for "Union All.Inputs[Union All Input 3].Columns[Title]" does not match the metadata for the associated output column.

Error at Data Flow Task [Union All [303]]: Failed to set property "OutputColumnLineageID" on "Union All.Inputs[Union All Input 3].Columns[Title]".

ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap)

BUTTONS:

OK

I keep getting this error when i try to do data conversion and then try to do union... This is because, if you know, the data conversion, will create new columns. SO when i try to do union with them, it will get the bove error.

enter image description here

sql-servervisual-studiossisetl


Solution 1:[1]

I had the same problem once and what I did was as follows:

1)Double click the respected data-conversion which faulty data is passing through 2)Check to see if all the data types for you columns are matching with the data type of same column from your other data-conversion. 3)Fix if there is any difference

And this will fix it for you, as it did for me.

Solution 2:[2]

Double click the UNION ALL component to display the output Column Names.

Change Union All Input 1 and the Union All Input 2 to

Rename you column and add a new column with the right name and the right data. Now you have the right column with the right types,you can delete your old renamed column.

Don't forget to update the derived column and destination compnenent. The will be updated automatically with the unwanted renamed column. Just configure the right column in these component and refresh. all will be right.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Kazem
Solution 2 MNF

Related Questions