Disable SSIS Data Validation

• Vollmer

  SSChasing Mays

  Points: 647

  More actions

  December 2, 2011 at 11:30 am

  #248943

  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.

• Vollmer

  SSChasing Mays

  Points: 647

  More actions

  December 2, 2011 at 11:46 am

  #1416137

  Resolved the metadatavalidation set to "FALSE" did work but I had to close the package and re-open for some reason.