SQLTeam.com | Weblogs | Forums

XML Source Help


#1

HI Guys,

I need urgent help. I am using XML Source and here is the error that I am getting
"For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the settings intoXmlReader.Create method."

Please guide me where should.

Thank You.


#2

A Bing search of the exact message string that you posted took me to this page that you will find useful.


#3

Thank You James. I found the same link and Info. However, I am/wasn't sure where should I add that syntax.

As far as fixing this, with a bit of looking around I found it was as simple as adding:

XmlReaderSettings settings = new XmlReaderSettings();
settings.ProhibitDtd = false;
and passing these settings into the create method.

Could you please guide me?

Thank You.


#4

If you have a create method in your code, or a constructor that creates the XmlReader, that is where you would pass the XmlReaderSettings object to. Look through your code to see where you are creating XmlReader.


#5

I am using SSIS/XML Source.


#6

SSIS XML Source does not support DTD based on my reading of this site.