Connection

Amazon S3 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.

SSH Connection

Overview

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

Setup

Use the SSH Connection Manager dialog to specify properties for connecting to an SSH-enabled server. The configuration dialog has server and proxy settings.

Server Options

Host

Specify the name or IP address of the SSH server.

Port

Specify the port number on the SSH server to use for the connection. The default value of this property is 22.

User name

Specify user name to access the SSH server.

Authenticate:

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

Value Description
By Password User is authenticated with password.

Selecting this value displays the dynamic option Password.
By Key File User is authenticated with private key file, unlocked with passphrase.

Selecting this value displays the dynamic options Key File, Passphrase.
Password

Specify password to access the SSH server.

Key File

Select private key file to access the SSH server.

Passphrase

Specify passphrase to unlock the private key file.

Time-out (secs)

Specify the number of seconds before timing out session connect. The default value of this property is 60.

Test Connection

Confirm connection manager configuration by clicking Test Connection.

Proxy Options

Proxy:

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

Value Description
None Proxy not specified
Tunnel Use tunnel (HTTP) proxy type.
SOCKS4 Use SOCKS4 proxy type.
SOCKS5 Use SOCKS5 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.

Package Connection

Overview

Package Connection Manager is SSIS Connection Manager for establishing connections to SSIS packages. It allows access to current or another package at runtime. This is important extension of the SSIS framework, which makes components like Data Flow Source possible. The configuration dialog allows connection setup to the current package or another package. Use the API to build components based on the Package Connection Manager.

Setup

Use the Package Connection Manager dialog to specify properties for connecting to SSIS package. Please check the options below, when setting connection to a package other than the current.

Package Options

Decryption Password

Specify the password to use to decrypt package.

Package location

Specify the type of package storage location. This property has the options listed in the following table.

Value Description
SQL Server Package is stored in SQL Server.

Selecting this value displays the dynamic option Server, Authentication type, Package path.
File System Package is stored on a file share.

Selecting this value displays the dynamic options Package path.
SSIS Package Store Package is stored in SSIS Package Store.

Selecting this value displays the dynamic options Server, Package path.
Server

Specify server name or select a server from the list.

Authentication type

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

Value Description
Windows Authentication User is authenticated using standard Windows Authentication.
SQL Server Authentication User is authenticated with SQL Server Authentication.

Selecting this value displays the dynamic options User name, Password.
User name

Specify user name to access the SQL server.

Password

Specify password to access the SQL server.

Package path

Type the package path, or click the browse button (…) and locate the package.

How to script and modify the variables of Package connection?

To iterate and modify the variables used by a package, follow these steps:

  1. Create a script task.
  2. Reference CozyRoc.SSISPlus library.
  3. In the script get reference to a package connection manager.
  4. Get connection manager InnerObject property and cast it to PackageConnectionManager.
  5. Get Variables property, which is generic Dictionary type. It contains variable name to variable value pairs. Modify this collection, to setup package connection variables.

 

Check the sample script below demonstrating how to access package connection variables.

Imports System.Collections.Generic
Imports CozyRoc.SqlServer.SSIS
...
Dim manager As ConnectionManager = Dts.Connections("YourPackageConnection")
Dim packageCM As PackageConnectionManager = CType(manager.InnerObject, PackageConnectionManager)
Dim packageVars As Dictionary(Of String, String) = packageCM.Variables

 

Syndicate content