Connection

Overview

SharePoint Connection Manager is SSIS Connection Manager for establishing SharePoint connections. Use the API to build components based on SharePoint Connection Manager.

Setup

Use the SharePoint Connection Manager dialog to specify properties for connecting to SharePoint service.

Server Options

Server: Specify the name or IP address of the SharePoint server.

User name: Specify user name to access SharePoint. If not specified, the connection will be established using Windows authentication.

Password: Specify password to access SharePoint.

Time-out (secs): Specify the number of seconds before timing out session connect. The default value of this property is 100 seconds.

RetainSameConnection

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value	Description
True	All clients use same connection (default).
False	Every client use different connection.

Test Connection: Confirm connection manager configuration by clicking Test Connection.

Proxy Options

Host: Specify the name or IP address of the proxy server. If not specified, proxy server is not used.

Port: Specify the port number on the proxy server to use for the connection.

User name: Specify user name to access the proxy server.

Password: Specify password to access the proxy server.

Overview

Excel Connection Manager is SSIS Connection Manager for processing data in Microsoft Excel workbook. Use the API to build components based on Excel Connection Manager.

Setup

Use the Excel Connection Manager dialog to specify properties for opening Excel workbook.

Excel Options

File: Specify Excel workbook file to open.

RetainSameConnection

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value	Description
True	All clients use same connection (default).
False	Every client use different connection.

Test Connection: Confirm connection manager configuration by clicking Test Connection.

Advanced Options

Format

Specify Excel workbook format. This property has the options listed in the following table.

Value	Description
Automatic	Automatically determines Excel workbook format from specified file extension (default).
Excel 97-2003	97-2003 Excel workbook.
Excel 2007	2007-2010 Excel workbook. Requires installation of .NET 3.0 or later.
Pocket Excel	Pocket Excel.

Open Password: Specify password to open Excel workbook.

Modify Password: Specify password to modify Excel workbook.

Recalculate

Specify to recalculate and update external references in Excel workbook on open. This property has the options listed in the following table.

Value	Description
True	Excel workbook is recalculated on open.
False	Excel workbook is not recalculated on open (default).

Overview

SMTP Connection Manager is SSIS Connection Manager for establishing connections with SMTP-enabled mail servers. Use the API to build components based on SMTP Connection Manager.

Setup

Use the SMTP Connection Manager dialog to specify properties to send mails.

Server Options

Connection Type

Specify connection type. This property has the options listed in the following table.

Value	Description
Unsecure	Unsecured SMTP connection.
ExplicitSSL	Use Explicit SSL SMTP.
ImplicitSSL	Use Implicit SSL SMTP.
ExplicitTLS	Use Explicit TLS SMTP.
ImplicitTLS	Use Implicit TLS SMTP.

Host: Specify the name or IP address of the SMTP server.

Port: Specify the port number on the SMTP server to use for the connection. The default value of this property is 25.

User name: Specify user name to access SMTP mail server. Optional.

Password: Specify password to access SMTP mail server. Optional.

Time-out (secs): Specify the number of seconds before timing out session connect. The default value of this property is 100 seconds.

RetainSameConnection

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value	Description
True	All clients use same connection (default).
False	Every client use different connection.

Test Connection: Confirm connection manager configuration by clicking Test Connection.

Advanced Options

Authentication

Specify authentication algorithm. This property has the options listed in the following table.

Value	Description
Auto	Automatically determines and uses the most secure available method.
Plain	Uses TLS plain text authentication.
DigestMD5	Uses DIGEST-MD5 authentication.
CramMD5	Uses CRAM-MD5 authentication.
Login	Uses login authentication.
Ntlm	Uses NTLM authentication.
GssApi	Uses GSSAPI/SSPI authentication.

Verbose log: Specify verbose log file name for investigating SMTP connection issues.

Proxy Options

Host: Specify the name or IP address of the proxy server. If not specified, proxy server is not used.

Port: Specify the port number on the proxy server to use for the connection.

User name: Specify user name to access the proxy server.

Password: Specify password to access the proxy server.

Overview

IMAP Connection Manager is SSIS Connection Manager for establishing connections with IMAP-enabled mail servers. Use the API to build components based on IMAP Connection Manager.

Setup

Use the IMAP Connection Manager dialog to specify properties for connecting to IMAP mail server.

Server Options

Connection Type

Specify connection type. This property has the options listed in the following table.

Value	Description
Unsecure	Unsecured IMAP connection.
ExplicitSSL	Use Explicit SSL IMAP.
ImplicitSSL	Use Implicit SSL IMAP.
ExplicitTLS	Use Explicit TLS IMAP.
ImplicitTLS	Use Implicit TLS IMAP.

Host: Specify the name or IP address of the IMAP server.

Port: Specify the port number on the IMAP server to use for the connection. The default value of this property is 143.

User name: Specify user name to access IMAP mail server.

Password: Specify password to access IMAP mail server.

Mailbox: Specify entry IMAP mailbox.

Time-out (secs): Specify the number of seconds before timing out session connect. The default value of this property is 100 seconds.

RetainSameConnection

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value	Description
True	All clients use same connection (default).
False	Every client use different connection.

Test Connection: Confirm connection manager configuration by clicking Test Connection.

Advanced Options

Authentication

Specify authentication algorithm. This property has the options listed in the following table.

Value	Description
Auto	Automatically determines and uses the most secure available method.
Plain	Uses TLS plain text authentication.
DigestMD5	Uses DIGEST-MD5 authentication.
CramMD5	Uses CRAM-MD5 authentication.
Login	Uses login authentication.
ClearText	Uses clear text USER/PASS authentication.
Ntlm	Uses NTLM authentication.
External	Uses external authentication.
GssApi	Uses GSSAPI/SSPI authentication.

Verbose log: Specify verbose log file name for investigating IMAP connection issues.

Proxy Options

Host: Specify the name or IP address of the proxy server. If not specified, proxy server is not used.

Port: Specify the port number on the proxy server to use for the connection.

User name: Specify user name to access the proxy server.

Password: Specify password to access the proxy server.

Overview

POP3 Connection Manager is SSIS Connection Manager for establishing connections with POP3-enabled mail servers. Use the API to build components based on POP3 Connection Manager.

Setup

Use the POP3 Connection Manager dialog to specify properties for connecting to POP3 mail server.

Server Options

Connection Type

Specify connection type. This property has the options listed in the following table.

Value	Description
Unsecure	Unsecured POP3 connection.
ExplicitSSL	Use Explicit SSL POP3.
ImplicitSSL	Use Implicit SSL POP3.
ExplicitTLS	Use Explicit TLS POP3.
ImplicitTLS	Use Implicit TLS POP3.

Host: Specify the name or IP address of the POP3 server.

Port: Specify the port number on the POP3 server to use for the connection. The default value of this property is 110.

User name: Specify user name to access POP3 mail server.

Password: Specify password to access POP3 mail server.

Time-out (secs): Specify the number of seconds before timing out session connect. The default value of this property is 100 seconds.

RetainSameConnection

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value	Description
True	All clients use same connection (default).
False	Every client use different connection.

Test Connection: Confirm connection manager configuration by clicking Test Connection.

Advanced Options

Authentication

Specify authentication algorithm. This property has the options listed in the following table.

Value	Description
Auto	Automatically determines and uses the most secure available method.
Plain	Uses TLS plain text authentication.
DigestMD5	Uses DIGEST-MD5 authentication.
CramMD5	Uses CRAM-MD5 authentication.
Login	Uses login authentication.
ClearText	Uses clear text USER/PASS authentication.
Apop	Uses APOP authentication.
Ntlm	Uses NTLM authentication.
GssApi	Uses GSSAPI/SSPI authentication.

Verbose log: Specify verbose log file name for investigating POP3 connection issues.

Proxy Options

Host: Specify the name or IP address of the proxy server. If not specified, proxy server is not used.

Port: Specify the port number on the proxy server to use for the connection.

User name: Specify user name to access the proxy server.

Password: Specify password to access the proxy server.

Overview

Dynamics CRM Connection Manager is SSIS Connection Manager for establishing Dynamics CRM connections. Use the API to build components based on Dynamics CRM Connection Manager.

Setup

Use the Dynamics CRM Connection Manager dialog to specify properties for connecting to Dynamics CRM service.

Server Options

Deployment Type

Specify deployment type. This property has the options listed in the following table.

Value	Description
Premise	Connect to on-premise Dynamics CRM server.
Live	Connect to Dynamics CRM Live service.
Hosted	Connect to hosted Dynamics CRM.
CRM 3.0	Connect to Dynamics CRM 3.0.

User name: Specify user name to access Dynamics CRM.

Password: Specify password to access Dynamics CRM.

Organization: Select organization name. Note: Not available in CRM 3.0

Time-out (secs): Specify the number of seconds before timing out session connect. The default value of this property is 100 seconds.

RetainSameConnection

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value	Description
True	All clients use same connection (default).
False	Every client use different connection.

Test Connection: Confirm connection manager configuration by clicking Test Connection.

Proxy Options

Host: Specify the name or IP address of the proxy server. If not specified, proxy server is not used.

Port: Specify the port number on the proxy server to use for the connection.

User name: Specify user name to access the proxy server.

Password: Specify password to access the proxy server.

Overview

Salesforce Connection Manager is SSIS Connection Manager for establishing Salesforce connections. Use the API to build components based on Salesforce Connection Manager.

Setup

Use the Salesforce Connection Manager dialog to specify properties for connecting to Salesforce service.

Server Options

User name: Specify user name in email-like format.

Password: Specify password to access Salesforce service.

Time-out (secs): Specify the number of seconds before timing out session connect. The default value of this property is 60 seconds.

RetainSameConnection

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value	Description
True	All clients use same connection (default).
False	Every client use different connection.

Test Connection: Confirm connection manager configuration by clicking Test Connection.

Advanced Options (1.4 SR-1)

Server URL (1.4 SR-1)

Specify Salesforce service URL. This property should be explicitly specified when doing sandbox testing. Sample URLs:

Proxy Options (1.4 SR-3)

Host (1.4 SR-3): Specify the name or IP address of the proxy server. If not specified, proxy server is not used.

Port (1.4 SR-3): Specify the port number on the proxy server to use for the connection.

User name (1.4 SR-3): Specify user name to access the proxy server.

Password (1.4 SR-3): Specify password to access the proxy server.

Overview

FTPS Connection Manager is SSIS Connection Manager for establishing FTP over SSL connections. Use the API to build components based on FTPS Connection Manager.

Setup

Use the FTPS Connection Manager dialog to specify properties for connecting to an FTP over SSL server. The configuration dialog has server and proxy settings.

Server Options

Connection Type

Specify connection type. This property has the options listed in the following table.

Value	Description
Unsecure	Unsecured FTP connection.
ExplicitSSL	Use Explicit SSL FTPS.
ImplicitSSL	Use Implicit SSL FTPS.
ExplicitTLS (1.3 SR-1)	Use Explicit TLS FTPS.
ImplicitTLS (1.3 SR-1)	Use Implicit TLS FTPS.

Host: Specify the name or IP address of the FTPS server.

Port: Specify the port number on the FTPS server to use for the connection. The default value of this property is 21.

User name: Specify user name to access the FTPS server.

Password: Specify password to access the FTPS server. Specify arbitrary value for anonymous account.

Time-out (secs): Specify the number of seconds before timing out session connect. The default value of this property is 60 seconds.

RetainSameConnection (1.3 SR-5)

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value	Description
True	All clients use same connection.
False	Every client use different connection (default).

Test Connection: Confirm connection manager configuration by clicking Test Connection.

Advanced Options (1.3 SR-5)

Password Protection (1.3 SR-2)

Note: Starting from 1.4 SR-3 this option is no longer needed because it is automatically determined.

Specify OTP S/Key password protection. This property has the options listed in the following table.

Value	Description
None	No password protection.
MD4	MD4 password protection.
MD5	MD5 password protection.

Certificate file (1.3 SR-5): Select client certificate file.

Certificate password (1.3 SR-5): Select client certificate password.

Data transfer passive mode (1.3 SR-5)

Specify what mode to use for data connections. This property has the options listed in the following table.

Value	Description
True	Use passive mode for data connections (default).
False	Use active mode for data connections.

Ignore server IP in passive mode (1.4 SR-2)

Specify if the reported server address in passive mode is ignored. This property has the options listed in the following table.

Value	Description
True	The reported server address is ignored. Use this setting when when the IP address is unroutable.
False	The reported server address is not ignored (default).

Verbose log (1.5): Specify verbose log file name for investigating FTPS connection issues.

Use binary transfer (1.5): Specify to use binary mode for file transfers.

Clear Command Channel (1.5): Specify to use clear command channel, after authenticating to the remote server. The data connections are still encrypted. Use this option when you have introspecting firewall, which dynamically opens data ports required by the FTPS.

BackendVersion (1.5)

Specify FTPS backend engine in use. This property has the options listed in the following table.

Value	Description
1	Use legacy FTPS backend engine.
2	Use new 1.5 FTPS backend engine (default).

Note: This property is not visible in the connection manager dialog.

Proxy Options

Proxy:

Specify proxy type. This property has the options listed in the following table.

Value	Description
None	Proxy not specified
SOCKS4	Use SOCKS4 proxy type.
SOCKS5	Use SOCKS5 proxy type.
HTTP	Use HTTP proxy type.
FTPSite	Use FTP w/ SITE proxy type. Available only for unsecured connection type.
FTPOpen	Use FTP w/ OPEN proxy type. Available only for unsecured connection type.
FTPUser (1.3 SR-1)	Use FTP w/ USER proxy type. Available only for unsecured connection type.

Host: Specify the name or IP address of the proxy server.

Port: Specify the port number on the proxy server to use for the connection. The default value of this property is 80.

User name: Specify user name to access the proxy server.

Password: Specify password to access the proxy server.

Overview

Jabber Connection Manager is SSIS Connection Manager for establishing connections with Jabber/XMPP server. Use the API to build components based on Jabber Connection Manager.

Setup

Use the Jabber Connection Manager dialog to specify properties for connecting to Jabber server. The configuration dialog has server and proxy settings.

Server Options

User name: Specify the Jabber user name in email-like format.

Password: Specify user password to access the Jabber server.

Host: Specify the network host of the Jabber server. Set this option if you have issues resolving the domain name of the Jabber server.

Port: Specify the port number on the Jabber server to use for the connection. The default value of this property is 5222.

Use plain text authentication: Specify to use plain text authentication when connecting to the Jabber server.

Use SSL: Specify to use secure-sockets layer when connecting to the Jabber server.

Connection Type

Specify connection type to Jabber server. This property has the options listed in the following table.

Value	Description
Socket	Use "Normal" XMPP socket.
HTTP_Polling	Use XMPP protocol extension that enables access to a Jabber server from behind firewalls which do not allow outgoing sockets on port 5222, via HTTP requests Selecting this value enables the option URL
HTTP_Binding	Use a transport protocol specification that emulates a bidirectional stream between two entities (such as a client and a server) by efficiently using multiple synchronous HTTP request/response pairs without requiring the use of polling or asynchronous chunking. Selecting this value enables the option URL

Value

Description

Socket

Use "Normal" XMPP socket.

HTTP_Polling

Use XMPP protocol extension that enables access to a Jabber server from behind firewalls which do not allow outgoing sockets on port 5222, via HTTP requests

Selecting this value enables the option URL

HTTP_Binding

Use a transport protocol specification that emulates a bidirectional stream between two entities (such as a client and a server) by efficiently using multiple synchronous HTTP request/response pairs without requiring the use of polling or asynchronous chunking.

Selecting this value enables the option URL

URL: Contains the URL to poll on, or bind to. Related to Connection Type option.

Time-out (secs): Specify the number of seconds before timing out session connect. The default value of this property is 30.

Test Connection: Confirm connection manager configuration by clicking Test Connection.

RetainSameConnection

Specify to use same connection to Jabber server. This implies the connection to Jabber server will stay alive during the package execution. The default value of this property is true.

Remark(s):
Not visible in the connection manager user interface.

Proxy Options

Proxy

Specify proxy type. This property has the options listed in the following table.

Value	Description
None	Proxy not specified
SOCKS4	Use SOCKS4 proxy type.
SOCKS5	Use SOCKS5 proxy type.
CONNECT	Use HTTP CONNECT proxy type.

Host: Specify the name or IP address of the proxy server.

Port: Specify the port number on the proxy server to use for the connection. The default value of this property is 80.

User name: Specify user name to access the proxy server.

Password: Specify password to access the proxy server.

Amazon S3 Connection

Connection

Overview

Amazon S3 Connection Manager is SSIS Connection Manager for establishing connections with Amazon S3 service. Use the API to build components based on Amazon S3 Connection Manager.

Setup

Use the Amazon S3 Connection Manager dialog to specify properties for connecting to Amazon S3 service. The configuration dialog has server and proxy settings.

Server Options

Host: Specify the name or IP address of the Amazon S3 service.

Secure connection: Specify to establish secure HTTPS connection with Amazon S3 service on port 443.

Regular calling: Specify to connect to Amazon S3 service, using regular calling format. Un-check this option when connecting to EU Amazon S3 service.

Access Key: Specify access key for Amazon S3 service.

Secret Key: Specify secret key for Amazon S3 service.

Time-out (secs): Specify the number of seconds before timing out session connect. The default value of this property is 100.

Test Connection: Confirm connection manager configuration by clicking Test Connection.

Proxy Options

Host: Specify the name or IP address of the proxy server.

Port: Specify the port number on the proxy server to use for the connection. The default value of this property is 80.

User name: Specify user name to access the proxy server.

Password: Specify password to access the proxy server.

PASS Summit '10

November 8 - 11, 2010 Washington State Convention & Trade Center in Seattle, WA

CozyRoc will be exhibiting at the Premier Conference for SQL SERVER Professionals. Register with code CR3D and get $100 off.

CozyRoc SSIS+ has been nominated for the 2010 SQL Server Magazine Community Choice Awards, category "Best Business Intelligence & Reporting Product". Vote Now to help us win this prestigious award.