MS CRM SSIS Data Migration Data validation steps?

Pergunta MS CRM SSIS Data Migration Data validation steps?

  • segunda-feira, 20 de agosto de 2012 07:26
     
     

    what are the steps that we should follow inorder to make sure that valid data is dumped into MS CRM ...when transferring Data to MS CRM using SSIS.



    • Editado MSCRMrocks segunda-feira, 20 de agosto de 2012 14:52
    •  

Todas as Respostas

  • segunda-feira, 20 de agosto de 2012 07:28
     
     

    Hi,

    You can always use CRM out of the box feature to import data from CSV to CRM.

    This will lead you through the way. http://blogs.msdn.com/b/dynamicscrmonline/archive/2011/06/24/crm-2011-data-import-wizard-importing-related-accounts-and-contacts.aspx


    Thanks and regards,
    Hiren Solanki.
    Please vote or mark as a answer if it helped you.

  • segunda-feira, 20 de agosto de 2012 07:35
     
     

    Hi Solanki,

    we are having about 5 millions of records so we opted for SSIS package.But im not aware of validating process for the records inserted into MSCRM using SSIS package.

    I want a step by step guide to validate the imported data.
    Please help me

  • segunda-feira, 20 de agosto de 2012 10:43
     
     

    Hi ,

    There are some Data Flow Transformation controls on SSIS toolbox , because everybody can have various different validations for their data.

    Regards,

    Vilas


    Vilas Magar http://microsoftcrmworld.blogspot.com/