Migrate Records from one MS CRM Organization to another using SSIS Kingway Package


1 Create a new SSIS Integration Service Package.
2Right Click on SSIS Package and Add New SSIS Package.
3Go to Control Flow and add Data Flow Task.

4.      4.   Double click on data flow to navigate to Data flow
2.      Add Kingsway Dynamics CRM Source and destination 

6.        Connect the flow as shown below, Incase any error occur update the error message in OLEDB Destination(SQL Table).

7.        Run the Package.

Comments

Post a Comment

Popular posts from this blog

Display SSRS Report in CRM Dashboard with Paging and Hyperlink

Image
Open Visual Studio create a report project and add new report Go to Data Source provide Embedded  Connection Type : and Credentials as below(If it is online CRM connection type can be different). Create a Query and add it in Data Set Create a table and add columns to the table as below Watch this video   help to create paging in report https://www.youtube.com/watch?v=gvGvfKxy1r0 Right click on the report column "Company Name" select properties -> Select Action -> Go to Report Click on expression button and Add this Expression " =First(Fields!orgUrl.Value, "GetOrgUrl")+"/CRMReports/viewer/drillopen.aspx?ID={" & CType(Fields!companyId.Value, GUID).ToString &"}&LogicalName=account" "(In this expression i created one more Data Set to get organisation URL from configuration Record). Add Report in CRM Create a html Webresouce in CRM  <html> <head...
Read more