locked
How o integrate with SSIS for CRM 2011 RRS feed

  • Question

  • hi

    i need to integrate a CRM 2011 from SSIS 

    Is any help full blogs and solutions are there please suggest me

     

    thanks 


    Anwar noori
    Monday, October 17, 2011 2:25 PM

Answers

  • it is for CRM4.0, i need for CRM 2011
    Anwar noori
    CozyRoc Dynamics CRM adapters support CRM 2011, too.
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
    • Marked as answer by Eileen Zhao Monday, October 24, 2011 1:49 AM
    Tuesday, October 18, 2011 12:12 PM

All replies

  • Hello Anwar,

    what specifically do you need to achieve?


    Arthur My Blog
    By: TwitterButtons.com
    Monday, October 17, 2011 2:30 PM
  • Thanx for your reply ArthurZ

     

    i had a table with 5 contacts in sql server,just i need to convert that table records to crm 2011 contacts

    I think it is possible


    Anwar noori
    Monday, October 17, 2011 2:39 PM
  • I agree, SSIS seems to be the best choice

    You will need CRM SDK, then make sure to add CRM proxy class reference. In short, I think I found you a good walk through:

    https://community.dynamics.com/roletailored/customerservice/b/cscrmblog/archive/2008/05/07/integrating-crm-using-sql-integration-services-ssis.aspx

     


    Arthur My Blog
    By: TwitterButtons.com
    Monday, October 17, 2011 2:52 PM
  • hi

    i need to integrate a CRM 2011 from SSIS 

    Is any help full blogs and solutions are there please suggest me

     

    thanks 


    Anwar noori

    If you can use third-party solutions, check the commercial CozyRoc Dynamics CRM adapters. All three deployment types are supported (Premise, Hosted and Online). The Dynamics CRM integration consists of three parts:

    Dynamics CRM Connection Manager - Stores your credentials and provides higher level abstraction for working with CRM Data.

    Dynamics CRM Source component - For reading data from Dynamics CRM.

    Dynamics CRM Destination component - To create/update/delete CRM entity records.

    The adapters are completely integrated in SSIS and already used in production around the world.


    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
    Tuesday, October 18, 2011 1:19 AM
  • it is for CRM4.0, i need for CRM 2011
    Anwar noori
    Tuesday, October 18, 2011 4:55 AM
  • it is for CRM4.0, i need for CRM 2011
    Anwar noori
    CozyRoc Dynamics CRM adapters support CRM 2011, too.
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
    • Marked as answer by Eileen Zhao Monday, October 24, 2011 1:49 AM
    Tuesday, October 18, 2011 12:12 PM