CODEWITHSUNDEEP
dynamics-crmetlssis
hemanth
hemanth

Reputation: 587

How to load GUID values from one DB to Another DB using SSIS

I have two CRM's MS CRM 2011 (on-premise with SQL server 2008) and MS CRM 2011 (in the cloud).

I want to migrate data from on-premise to online using SSIS 2008, were i installed a third party components like "CRM Source Component" and "CRM Destination Component". Here when i'm trying to map all attribute from source to destination except auto generated fields(GUID) or lookup fields in CRM like Accountid, ParentCustomerid, territoryid(which are relationship fields(FK) with other entities) etc., data is moving perfectly else package is getting failed.

Here how can I load these missing attribute values into CRM?

Upvotes: 0

Views: 322

Answers (1)

user1826905
user1826905

Reputation: 568

It could be that you are violating the referential integrity constraints. Try removing ( temporarily) all the constraints on the destination tables before executing your package.

Upvotes: 2

Related Questions