Retrieve Contact GUID after insert for later update? RRS feed

  • Question

  • Hello - Using other resources I have written an SSIS package using a script component and OrganizationService that will insert records into CRM 2013. Now I find myself needing to update any existing records that have changed after a previous insert expect I do not know the Guid of the previously new person under the entity Contact. I do not have access to the SQL tables to do a join or look-up. 

    One thought I had was to after the insert have a new data flow task with script source component and look up all of the contacts and pull back every contactid and custom (PersonKey) field into a new mapping table on my side. Then I could use that to pass the Guid for each contactid in the update script component. However I cannot figure out how to create this script component source piece and after hours of trying various things I thought I would post on here for guidance. 

    I am using Visual Studio 2012 with SSDT. Thank you in advance for any help! - Justin 

    Tuesday, April 15, 2014 12:29 AM