Hi - I am getting exactly the same error and it is driving me nuts trying to resolve - seems ssis does not like the fact that the database is...

Thanks for that - yes, might have to look at shipping it out to SQL and restructuring it there.

Rgds

D

Sorry, hit the enter key - try again

===========================

Phil,

After I have carried out my 3 merge joins, I have the following dataset of 4 columns

LandStatus BuildingStatus ...

Phil,

After I have carried out my 3 merge joins, I have the following dataset

LandStatus BuildingStatus ComplexStatus DwellingStatus

THanks for the Reply Phil.

Still not sure what you mean; how do I merge/bleed these 4 cols into the one via a derived column task - I am...