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.

Dynamics 365 App for Outlook – How to setup?

When we need to use Dynamics 365 together with our familiar outlook email client, actually we have two options as Dynamics 365 Client for Outlook and Dynamics 365 App for Outlook.

Dynamics 365 Client for Outlook is actually the old method, which require manually installing the client in all machines. This supports off-line capabilities helping user in the field without internet connectivity. This gives all the necessary functionalities allowing users to adopt to Dynamics functions within the outlook but doesn’t work in mobile or web versions. Still biggest drawback is it pushes outlook to perform slow. Anyway, Microsoft has announced its deprecation.

Dynamics 365 App for Outlook is the successor. This supports all Outlook versions such as full client, web and mobile. No manual installation is required since D365 itself can be configured to push the add-in to Outlook. Since this uses Dynamics Web API to retrieve real data this App is very fast. Anyway, Server-side synchronization with Exchange is required.

Let’s check how to set-up Dynamics 365 App for Outlook and tracking records;

1) Configure exchange as explained here.

2) Configure Dynamics 365 CE

Browse to Apps for Dynamics 365 by clicking settings button.

You will see below;

Once click Microsoft Dynamics 365 App for Outlook, you should see below notice if everything is in order.

3) Dynamics 365 CE functionality in Outlook

Now you will see Dynamics 365 icon in right hand corner of the Outlook as below;

Once you select e-mails, relevant Dynamics 365 data will be loaded in new pane appear in right hand-side

a. Email from a Contact

b. Email from a User

c. Email from unknown person

Now it is allowed to create a Contact or Account using this record.

Showing auto-populated fields prior to saving the record.

d. Set regarding record - Click the three dots below the Set Regarding label to associate any D365 record to this email

e. Track Record – Click three dots after Not Tracked label to track the record in D365.

f. New Email – It is possible to Track and Set Regarding for new emails as well

Some Notes on Tracking and Set Regarding;

If Track without setting the Set Regarding for a email (from known/ unknown party), it will create Email in D365 without a regarding object. This is not really useful since record will not be associated to anything. Still you can reply to this email from D365. So it is always encouraged setting the Set Regarding.

Also when Tracking emails from unknown party it's also encouraged to create a Contact (or lead etc.)

Anyway, if you Track an email in D365 from unknown party without creating a record (Contact, Lead etc.) it still allows to reply from D365. (** This is a special case where you can send a email to someone who is not a Contact, Lead , etc.)

Refer this article for complete guide on using Dynamics 365 App for Outlook.

Enabling Multi-Factor Authentication (MFA) for Microsoft users

Multi-factor authentication (aka MFA) is a new necessity in ever growing need for secure business systems. No exception for Dynamics 365. It is now possible for Dynamics since Microsoft users are easily enabled for MFA. In fact, any Microsoft application, including Dynamics products, are ready with MFA.

Let’s see the easy steps to enable MFA.

1.Enable users for MFA

Login to Office Admin center and click Active Users. Then click More> Multifactor Authentication Setup.

Resulting window will list down all the active users as below. Then you are allowed to pick the users those need MFA to be enabled and click Enable link.

Then you will see below general confirmation pop-up.

Upon confirmation, you will be notified on success of operation.

2. First time login

When user log to the system for the first time, below form will be presented to grab the phone number details.

One filled and submit, code will be sent to the given mobile for verification.

Once verify with the code, resulting pop-up will produce one important piece of information which is the app password. This is the password user is required to use for the situations mobile authentication is not possible such as Integrations and different apps (Outlook etc.).

3. Subsequent logins

Now user is MFA enabled. Each time user is sent a code to the mobile and requested to provide it prior to successful login.