Office 365 to SharePoint Migrating using SSIS integration toolkit
SSIS Integration Toolkit for Office 365 and understanding of SharePoint.
Migration in SharePoint is a challenging task for Member. with the help of SSIS Integration Toolkit make easy in migration.
Office 365 standard object:
· Account
· Contact
These are standard object which is used to migrate in Dynamics 365 with the assistance of SSIS Integration Toolkit make simple in migration.
Add a Office 365 connection with your SSIS package, right-click in the Connection Manager area, and click on New Connection Manager then open new window, where you can select the “Office 365” item to add the connection.
Add Connection for SharePoint.
Add a SharePoint connection with your SSIS package, right-click in the Connection Manager area, and click on New Connection Manager then open new window, where you can select the “SharePoint” item to add the connection.
Steps 1: Drag and drop Office 365 Source and SharePoint Destination component from SSIS Toolbox.
For example I have taken contact object, below are the following steps:
Steps 2: Set up the Office 365 Source SharePoint by adding the Connection Manager: “Office 365 Connection Manager”, Source Type: “Entity” and select Source Entity: “contact” for migrating.
Steps 3: Set up the target SharePoint Destination by setting the Connection Manager, choosing the appropriate Action (Create, Update, Upsert, Delete, Merge etc.) according to Destination List: Member.
Steps 4: Input Column field map to Destination CRM field.
For example: We need to directly map Company, Title, ContactID and Job_x0020_Title field of source to target CRM.
Then click on the Ok button.
Steps 5: Then Mapping is complete, now click on Right Button then click Execute Task.
Steps 6: Migration is now started.
