Hello,
I have an SSIS package that can pull data from 2 different data sources. Each source's data structure is the same except 1 table. The problem I am having is the SSIS data validation on the data flow fails when I switch my inbound source from 1 to the other, as that table does not exist on one of the sources. I have set the ValidateExternalMetaData to False, but it is still throwing the error on execution. I really need to be able to turn off MetaDataValidation for the one data flow task. Any help would be greatly appreciated.