Reputation: 12795
I'm trying to use the SSIS OData Source component to connect to the CRM OData Endpoint, but it's giving me the following error:
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 into XmlReader.Create method. (System.Xml)
Has anyone got this working before? Any tricks to prevent it from doing the DTD check?
The XML the service responds starts as the following:
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<service xml:base="https://url.com/XRMServices/2011/OrganizationData.svc/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:app="http://www.w3.org/2007/app" xmlns="http://www.w3.org/2007/app">
Upvotes: 0
Views: 3510
Reputation: 1000
playing with
you can achieve it. Our company created a blog post for that. sorry for not posting the whole solution here, it's kind of long
Upvotes: 1
Reputation: 12795
So, the problem is that the SSIS OData Connection won't do the OAuth dance, and as such fails to cope with CRM.
What I did instead was use the RSSBus CRM component to connect.
Upvotes: 1