SMTP Connection

1. Add an SMTP+ Connection Manager

2. On the Advanced tab of the new SMTP+ Connection select GoogleOAuth2.

3. Back on the Server tab of the SMTP Connection Manager:

- Select ImplicitTLS in the Connection Type drop down.
- Enter smtp.gmail.com in the Host field.
- Enter 465 for the Port field.
- Then in the File/Id dropdown choose the <New...> to begin the Token Authorization Wizard.

4. Click the External Browser radio button and then click the Next button.

5a. The token creation wizard moves on to a window that has a field where you will need to enter a URL created after logging on to an external browser session that popped open in the background.

5b. Simultaneously while step 5a window is open, a browser session opens in the background to log into the Google account. Log into the Google Account.

5c. Expand the Advanced link in the browser that prompts that the App has not been verified yet.

5d. Click on the link "Go to COZYROC SSIS+ (unsafe)"

5e. A request to give COZYROC SSIS+ access to 3 Google services in your account is presented. The three services are listed here. Note: this screen can look different depending on whether access has already previously been granted for the app to the services.

5f. If the services have been previously granted to the COZYROC SSIS+ app, then the grant access display would look something like this. Otherwise, checkboxes will display with unchecked boxes for the services that have not been granted yet. Click the Continue button.

5g. Click the Copy URL button.

5h. Enter the copied URL into the field provided in the current window of the token generation wizard and click the Next button.

6. The Access Token and the Refresh Token have been generated. Leave the Expiration date alone as the COZYROC component will manage the refresh token. Now you have a choice to either to save the token as a file or save it in a database. If you choose to save the token as a file, click the elipses button with three dots and enter the name and location of a file and then enter a password in the "Encrypt with password" field. If you choose to save the token in a Database, enter the connection string, Token Identifier and password to encrypt in the appropriate fields.

7. Once you have determined which way you want to save the token, click the OK button.

8. Test the connection by clicking the "Test Connection" button. The connection succeeded and click the OK button. The SMTP Connection Manager is now ready to use in the Send Mail Task.