locked
Using webservices while using CRM 2013 online with AFDS RRS feed

  • Question

  • Hi All,

    I have downlaoaded the WSDL for organization.svc and utilize this within a SSIS package (sql server integration services 2012) within a webservice task. At the second pane called input i am able to select a webservice method. When clicking the drop down the following error occurs 

    Cannot find definition for http://schemas.microsoft.com/xrm/2011/contracts/services:CustomBinding_IOrganizationService .

    Service description with namespace http://schemas.microsoft.com/xrm2011/contracts/services is missing. Parameter name : name

    So I cannot see any webservice method. Could this be related to the use of AFDS?

    Best regards,

    Johan

    Wednesday, December 3, 2014 11:21 PM

All replies

  • I don't think you can use a webservice task to access Crm data in SSIS. There are 2 reasons for this: The authentication model, and the fact that Crm using relatively complex datatypes in the web services.

    However, there are 2 alternate options to access the Crm data in SSIS:

    1. Using a Script Component. As you're using SQL 2012 (and hence VS 2010), you can use the Crm SDK assemblies, rather than setting a service reference (it's a lot easier with ADFS to use the Crm SDK assemblies)
    2. Use 3rd party components, e.g. Kingswaysoft or CozyRoc

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

    Thursday, December 4, 2014 8:36 PM
    Moderator