Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SergioM
Posting Yak Master
170 Posts |
 Posted - 2011-10-08 : 09:52:40
|
I'm trying to use Union All in an SSIS package, but I get the following error in the screen where I try to map the 5 fields together. quote:
TITLE: Microsoft Visual Studio------------------------------Error at Integrate Feeds [Union All [577]]: The metadata for "input column ""BRAND NAME"" (676)" does not match the metadata for the associated output column.Error at Integrate Feeds [Union All [577]]: Failed to set property "OutputColumnLineageID" on "input column ""BRAND NAME"" (676)".------------------------------ADDITIONAL INFORMATION:Exception from HRESULT: 0xC0204006 (Microsoft.SqlServer.DTSPipelineWrap)------------------------------BUTTONS:OK------------------------------
At first, I thought it was because the data-types were disparate, so I added an extra conversion after each source. But I continue to get the same error. Does anyone know why the error occurs? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-08 : 09:55:24
|
| whats the data type of BRAND NAME in input and output pipline?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
SergioM
Posting Yak Master
170 Posts |
Posted - 2011-10-08 : 13:06:31
|
| "Brand Name" does not allow me to define it straight out of the flat file. So I don't know the file type going into "Data Conversion 3". The output from "Data Conversion 3" is "string [DT_STR]" with a length of "50" & a Code page "1252 (ANSI - Latin I)". |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-08 : 13:20:11
|
| see if input its coming as unicode. also see if all sources the type is same?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Union All resulting in Error