At task runtime, the step fails with error:
Error validating source XML against schema - The element 'ELEMENT_NAME' has invalid child element ‘ELEMENT_NAME'
The error is caused by an invalid schema from the input data source, i.e. the Database Query step will be the input data source.
To resolve the error, open the Database Query step and make a minor change, for example, key in a line break or a space character. When you click OK to save the change you will get a prompt to “execute this new query to read the new schematics?” Click yes to accept the prompt.