Mar 31, 2014

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.


In SSIS when we will create task where data source is XML source.

We may get a warning message like:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

Cause: Your XML file also contains DTD (Document Type Definition).  

Solution: SSIS doesn't support DTD in XML file. So remove the all DTD from your XML file.

8 comments:

  1. Nice blog thanks for sharing Karuna Nursery is the Best Plant Nursery in Chennai.
    plant nursery in chennai
    rental plants in chennai
    corporate gardening service in chennai

    ReplyDelete
  2. Excellent blog thanks for sharing Pixies Beauty Shop is unlike any of the other cosmetic shops in Chennai. With tons of exclusive imported brands to choose from and the best value, this is the best shopping destination for your personal and salon needs.

    ReplyDelete