Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
greenmtnsun
Starting Member
13 Posts |
 Posted - 2007-09-04 : 16:37:14
|
| I am downloading an XML file from a trusted source and would like to allow for DTD inside an XML file that is being downloaded through SSIS. Can anyone tell me how can I set the ProhibitDTD in the XMLReaderSettings to false for SSIS processing? I can't find anyone who can tell me how to tell MSXML 6.0 that SSIS can allow DTD. This document from MS seems useless for an SSIS developer: http://msdn2.microsoft.com/en-us/library/ms761392.aspx The error I am getting is: [XML Source [1]] Error: The component "XML Source" (1) was unable to read the XML data. DTD is prohibited in this XML document. The following thread outlines a work around that I wasn't able to impliment. We want to simply allow DTD instead of stripping it out like this talks about. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1885322&SiteID=1 Any assistance would be greatly appreciated! Keith |
|
|
|
|
|
How can I allow DTD?