NEW: Check our new hosted service COZYROC Cloud ...
Exchange Connection
Exchange Connection Manager is SSIS Connection Manager for establishing Exchange connections. It is based on Microsoft Exchange Web Services Managed Parameters
Server
Use the Server page of the Exchange Connection Manager dialog to specify parameters for connecting to Exchange mail service.
- Test Connection
- Confirm connection manager configuration by clicking Test Connection.
Specify to auto-discover host address from specified user name. This parameter has the options listed in the following table.
Value Description True Auto-discover host address (default). False Host address has to be explicitly specified. Specify the name or IP address of the Exchange server.
Specify user name to access Exchange.
Specify password to access Exchange.
Specify entry Exchange mailbox. To specify sub-mailbox use backslash (\). Starting from 1.6 SR-4, the connection manager can connect to another user mailbox by specifying the email address of the user before the initial backslash.
Specify the number of seconds before timing out session connect. The default value of this parameter is 100 seconds.
Specify if all clients should use the same connection. This parameter has the options listed in the following table.
Value Description True All clients use same connection (default). False Every client use different connection. Specify the email address of the user to impersonate.
Not visible in the connection manager user interface.Select authentication token file.
Specify token file password.
Proxy
Use the Proxy page of the Exchange Connection Manager dialog to specify properties if your server is behind firewall.
Specify the name or IP address of the proxy server. If not specified, proxy server is not used.
Specify the port number on the proxy server to use for the connection.
Specify user name to access the proxy server.
Specify password to access the proxy server.
Knowledge Base
- Where can I find the documentation for the Exchange Connection?
- How to connect to a Shared Mailbox?
- How to trace HTTP(S) and REST API using Fiddler
- Error Message: The connection type "xxxx" specified for connection manager "xxxx" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
Related scripts
What's New
2.1
- New: Implemented to create OAuth2 version 2.0 access tokens for Exchange Online.
1.9
- New: Support for Exchange Online token-based authentication.
1.7 SR-2
- Fixed: Unable to set Mailbox parameter with expression (Thank you, Carl).
- New: Enabled support for TLS 1.1 and 1.2 protocols.
1.6 SR-4
- New: A new parameter ImpersonatedUser.
- New: Support for opening of another user mailbox with delegated access.
1.6 SR-1
- Fixed: Failed with error "Value cannot be null. Parameter name: uniqueId" when retrieving list of email (Thank you, Carsten).
1.6
- New: Introduced connection.
Related documentation
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.