Jeff
Jeff

Reputation: 12795

SSIS connecting to CRM OData endpoint dtd error

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

Answers (2)

camous
camous

Reputation: 1000

playing with

  • crm online
  • azure active directory
  • ssis
  • C# (script component)
  • xml transformation

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

Part 1 Part 2

Upvotes: 1

Jeff
Jeff

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

Related Questions