Union All Task Error in SSIS [Resolved]

Posted by Bandi under Sql Server on 9/22/2014 | Points: 10 | Views : 1682 | Status : [Member] [MVP] | Replies : 1
Hi All,

I have two 'derived column' tasks and one 'Union all' task to combine the results of two sources.

I was able to run the package without failure at very first time. After that i have changed the derived column expression to do some modifications to the package.

Note: just changed derived column expression to concat some hard coded string for more clarification.

After doing the above change, got the following error on 'Union All' task

"The metadata for "combine 2 sets of rows.Inputs[Union All Input 3].Columns[ImportNotes]" does not match the metadata for the associated output column."

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif



Responses

Posted by: Bandi on: 9/22/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down

Resolved
One of the possible solution is to delete the mapping of that changed column and then re-create mapping.

It has fixed my issue now....

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Bandi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response