/n software Tasks for SSIS
/n software Tasks for SSIS
Questions / Feedback?

S3 Tasks

Properties   Configuration Settings  

The S3 Task provides access to Amazon's Simple Storage Service (S3).

Remarks

The S3 Task allows you to access Amazon's Simple Storage Service (S3) securely over an SSL connection. S3 allows you to store arbitrary data in buckets on Amazon's server and access them from anywhere using an Internet connection. Please refer to Amazon S3 documentation for additional details.

You will first need to sign up for the S3 service and obtain the AccessKey and SecretKey from Amazon. Once you have a valid AccessKey and SecretKey, you may begin uploading/downloading files to and from your buckets.

S3 Receive Task

The S3 Receive Task will download objects specified by the ObjectMask property contained within the Bucket. The AccessKey and SecretKey properties must be set in order to authenticate with the Amazon server. If you wish to enable SSL, you can turn it on by setting the UseSSL property to true and setting an appropriate SSLCert and SSLAcceptServerCert.

S3 Send Task

The S3 Send Task requires a Bucket and a ObjectKey to specify the location to upload to. The AccessKey and SecretKey properties must be set in order to authenticate with the Amazon server. If you wish to enable SSL, you can turn it on by setting the UseSSL property to true and setting an appropriate SSLCert and SSLAcceptServerCert.

Receiver Property List


The following is the full list of the properties of the receiver task with short descriptions. Click on the links for further details.

AccessKeyThe Access Key Id for the Amazon Web Services account.
BucketThe name of the current bucket.
BucketListString denoting the name of the variable which contains the last bucket listing entries.
EncryptionPasswordThe password to use when encrypting the object.
FirewallA set of properties related to firewall access.
HTTPProxyA set of properties related to proxy access.
LocalDirectoryThe directory on the local machine to write downloaded objects to.
LogFileThe file to write logging information to at runtime.
LogModeWhat information gets logged during task execution.
ObjectListString denoting the name of the variable which contains the last object listing entries.
ObjectMaskIndicates the type of files to download from the S3 server.
OperationThe operation which will be executed by the S3 task.
OtherDefines a set of configuration settings to be used by the task.
OverwriteWhether or not the task should overwrite files during transfer.
RuntimeLicenseSpecifies the task runtime license key.
SecretKeyThe Secret Access Key for the Amazon Web Services account.
SSLAcceptServerCertInstructs the task to unconditionally accept the server certificate that matches the supplied certificate.
SSLAcceptServerCertAcceptAnyTells the task to accept any server certificate.
SSLCertThe certificate to use for client authentication during the SSL handshake.
TimeoutA timeout for the task.
UseSSLUse SSL to access Amazon S3.
UseVirtualHostingDetermines which style request to use.

Sender Property List


The following is the full list of the properties of the sender task with short descriptions. Click on the links for further details.

AccessKeyThe Access Key Id for the Amazon Web Services account.
AccessPolicyThe AccessPolicy are used to set permissions when an object is updated.
BucketThe name of the current bucket.
ContentDispositionContent disposition for the object.
ContentTypeContent type for the object.
EncryptionPasswordThe password to use when encrypting the object.
FirewallA set of properties related to firewall access.
HTTPProxyA set of properties related to proxy access.
LocalFileThe path to a local file for upload.
LogFileThe file to write logging information to at runtime.
LogModeWhat information gets logged during task execution.
ObjectKeyThis is the name of file being uploaded to the server.
OtherDefines a set of configuration settings to be used by the task.
RuntimeLicenseSpecifies the task runtime license key.
SecretKeyThe Secret Access Key for the Amazon Web Services account.
SSLAcceptServerCertInstructs the task to unconditionally accept the server certificate that matches the supplied certificate.
SSLAcceptServerCertAcceptAnyTells the task to accept any server certificate.
SSLCertThe certificate to use for client authentication during the SSL handshake.
TimeoutA timeout for the task.
UseSSLUse SSL to access Amazon S3.
UseVirtualHostingDetermines which style request to use.

Configuration Settings


The following is a list of configuration settings for the task with short descriptions. Click on the links for further details.

DirDelimiterThe delimiter for subfolders on the S3 server that should not be maintained in the local directory.
IgnoreBucketRestrictionsAllows the user to ignore Amazon-defined bucket name restrictions.
IncludeObjectMD5Includes the MD5 digest of the object data if set.
LocationConstraintThe region where buckets will be created.
ObjectDelimiterA delimiter that can be used to roll up a bunch of keys.
ObjectMarkerA marker for the object(s).
ObjectPrefixA prefix for the object(s).
MaxObjectsThe maximum number of objects for the server to return.
ProcessAllPagesWhether or not to continue processing if results are paged.
SessionTokenThe session token to send in the request when using temporary credentials.
StorageClassSpecify the storage class to be used for the uploaded object.
URLIf set, the default URL will be overridden by this value.
UseEC2RoleCredsIf set to true, authenticate requests with credentials obtained from the IAM role attached to the EC2 instance.
UseServerSideEncryptionIf true, use server side encryption.
ReuseSSLSessionDetermines if the SSL session is reused.
SSLCipherStrengthThe minimum cipher strength used for bulk encryption.
SSLEnabledProtocolsUsed to enable/disable the supported security protocols.
SSLIncludeCertChainWhether the entire certificate chain is included in the SSLServerAuthentication event.
SSLSecurityFlagsFlags that control certificate verification.
SSLEnabledCipherSuitesThe cipher suite to be used in an SSL negotiation.
TLS12SignatureAlgorithmsDefines the allowed TLS 1.2 signature algorithms when UseInternalSecurityAPI is True.
TLSNamedGroupsThe supported (EC)DHE groups.
TLS13SignatureAlgorithmsThe allowed certificate signature algorithms.
AbsoluteTimeoutDetermines whether timeouts are inactivity timeouts or absolute timeouts.
LocalHostThe name of the local host or user-assigned IP interface through which connections are initiated or accepted.
TcpNoDelayWhether or not to delay when sending packets.
UseInternalSecurityAPITells the task whether or not to use the system security libraries or an internal implementation.

 
 
Copyright (c) 2019 /n software inc. - All rights reserved.
/n software Tasks for SSIS - Version 16.0 [Build 7240]