SSIS Connections cannot be changed

This a quite common issue you would come across, especially if you want to change the Data Source  of a SSIS Package and check some functionality against a different data source. Issue is, how many times you change it from Connection Manager (ex. Server Name), it jumps back to the previous value.

Reason behind this behavior is these details are associated with Parameters and sometimes it may be not present in the view.

You can right click the Project.params and view the code in such cases as shown below;

Now inspect the code;

You will realize that previous details (ex. Server) are set as shown above and they doesn't get change when you change the Connection Manager from UI. So you need to change this file with new details. This fix the issue.

Migrate Connections using Kingswaysoft Adapter

We all use Kingswaysoft Adapter to migrate data to Dynamics CRM. Just thought of sharing related tricks.

Here I reveal how to migrate connection, which can be little tricky than other entities. Important part is we need Connection roles are configured correctly. In my example, Employee and Employer Roles needs to be configured as illustrated below.

Account (i.e. Organisation in given example) is Employer and Contact (i.e. Individual in given example) is Employee. See how they associated with each other and enabled for particular entities.
Now see the fields we need to map with relevant information. We pass correct texts for Roles and Guids for related records. We need to pass object type code as well.

Actual fields we are mapping here as below;

Record1id = Connected To
Record1roleid = Role (To)
Record2id = Connected From
Record2roleid = Role (From)

For Roles need to resolve with Primary field as below since we are passing the names. For the safe side I enable the "Ignore Case". Still we need to make sure spellings are correct.

Object Type Code for Custom entities
This is tricky since this value can be different based on environment. Just check the URL of an open record of same type to obtain it.