SQS Tasks

Properties   Configuration Settings  

The SQS Task provides access to Amazon's Simple Queue Service (SQS).

Remarks

The SQS Task connects to Amazon's SQS service to download or upload messages in queues. SQS allows you to create globally accessible queues on Amazon's servers. These queues can be used by developers to transfer data between distributed application components, without losing messages or requiring each component to always be available. Please refer to Amazon SQS documentation for details.

To begin set AccessKey and SecretKey to the corresponding values for the AWS account. Queue specifies the existing queue to work with.

SQS Receive Task

The SQS Receive Task will download messages from the specified Queue. To delete messages after they are downloaded set DeleteMode to OnSuccess.

By default if messages are not deleted they may be returned in subsequent polling intervals if they are still present in the queue. To prevent duplicate messages from being downloaded even if they are still present in the SQS queue set DownloadCacheFile to a file on disk where information about downloaded message is stored. When DownloadCacheFile is specified the task will check if the message has previously been downloaded, and will skip it if so.

SQS Send Task

The SQS Send Task uploads messages to the specified Queue. The SQS Send Task is designed to be simple to use and requires only minimal configuration. Simply set Message to the SQS message content to be uploaded.

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 for the Amazon Web Services account.
DeleteControls if the message is deleted from the queue after download.
DownloadCacheFileThe file location where downloaded message information is cached.
FirewallA set of properties related to firewall access.
HTTPProxyA set of properties related to proxy access.
LocalDirectoryThe directory on the local machine to which messages are downloaded.
LogFileThe file to write logging information to at runtime.
LogModeWhat information gets logged during task execution.
MaxMessagesThe maximum number of messages retrieved from the queue.
MessageIdThe ID(s) of the message to delete when the operation is set to DeleteMessage.
MessageListString denoting the name of the variable which contains the last object listing entries.
OperationThe operation which will be executed by the SQS task.
OtherDefines a set of configuration settings to be used by the task.
QueueThe name of the queue to access.
QueueListString denoting the name of the variable which contains the last queue listing entries.
QueuePrefixQueuePrefix can be used to filter the queues listed.
RuntimeLicenseSpecifies the task runtime license key.
SecretKeyThe Secret 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.
UseFIFOQueueWhether the task should use FIFO queues instead of standard queues.
VisibilityTimeoutThe visibility duration for messages in the queue in seconds.

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 for the Amazon Web Services account.
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.
MessageThe message to add to the specified queue.
MessageGroupIdThe ID that groups together messages in a FIFO queue.
OtherDefines a set of configuration settings to be used by the task.
QueueThe name of the queue to access.
RuntimeLicenseSpecifies the task runtime license key.
SecretKeyThe Secret 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.
UseFIFOQueueWhether the task should use FIFO queues instead of standard queues.

Configuration Settings


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

URLIf set, the default URL will be overridden by this value.
UseEC2RoleCredentialsIf set to true, authenticate requests with credentials obtained from the IAM role attached to the EC2 instance.
ReuseSSLSessionDetermines if the SSL session is reused.
SSLCipherStrengthThe minimum cipher strength used for bulk encryption.
SSLEnabledCipherSuitesThe cipher suite to be used in an SSL negotiation.
SSLEnabledProtocolsUsed to enable/disable the supported security protocols.
SSLIncludeCertChainWhether the entire certificate chain is included in the SSLServerAuthentication event.
SSLSecurityFlagsFlags that control certificate verification.
TLS12SignatureAlgorithmsDefines the allowed TLS 1.2 signature algorithms when UseInternalSecurityAPI is True.
TLS13SignatureAlgorithmsThe allowed certificate signature algorithms.
TLSNamedGroupsThe supported (EC)DHE groups.
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) 2021 /n software inc. - All rights reserved.
/n software Tasks for SSIS - Version 20.0 [Build 7723]