SSIS using ODATA Source to connect to CRM 2015 Online RRS feed

  • Question

  • Hi,

    I am unable to connect using SSIS OdataSource with CRM Online 2015 Organization service.


    Has anyone successfully implemented it ? I am unable to connect to CRM Online using Odata Source in SSIS.

    I get 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)

    Program Location:

       at System.Xml.XmlTextReaderImpl.Throw(Exception e)
       at System.Xml.XmlTextReaderImpl.ThrowWithoutLineInfo(String res)
       at System.Xml.XmlTextReaderImpl.ParseDoctypeDecl()
       at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
       at System.Xml.XmlTextReaderImpl.Read()
       at Microsoft.SqlServer.IntegrationServices.OData.UI.ODataConnectionManagerForm.TestConnectionMiddle(Object callback)

    I came across this forum - http://stackoverflow.com/questions/25881389/ssis-connecting-to-crm-odata-endpoint-dtd-error

    "It says SSIS ODataComponent" does not do OAuth and I will need to implement "RSSBUS CRM Component" instead.

    • Edited by Sath13 Friday, March 13, 2015 6:30 AM
    Friday, March 13, 2015 5:09 AM

All replies

  • I'm not sure if you can access the OrganizationData.svc from SSIS - among other issues I don't think you can pass the authentication data. I would suggest you use the SOAP endpoint (Organization.svc) instead

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Monday, March 16, 2015 4:39 PM
  • 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

    • Edited by fcamous Thursday, March 24, 2016 6:04 PM
    Thursday, March 24, 2016 6:04 PM