XMPP Tasks

Properties   Configuration Settings  

The XMPP Task adds instant messaging functionality to your SSIS Package.


eXtensible Messaging and Presence Protocol is a highly extensible instant message service based on XML packets. The XMPP Task is a lightweight XMPP instant messaging client which enables you to send instant messages to any XMPP client within your service's network.

XMPP Send Task

At a minimum, you must supply an IMServer, IMPort for the connection and a ToJID for the intended recipient of the message. In order to authenticate with the XMPP server you will need to specify a User and Password. The AuthMethods property contains a preferential list of authentication methods to be enabled on the task.

The task will send the contents of the MessageText property as the instant message body. The task also supports sending HTML in the message body via the MessageHTML property.

A simple text message in the MessageText property can alternatively be treated as HTML via the TreatMessageAsHTML configuration setting. Also, when sending to clients that may not support reading HTML entities, ParseHTML can be set to cause the task to parse an HTML entity into the simple text body of the instant message.

The XMPP Send Task has support for SSL transport layer security. This may be enabled by setting SSLStartMode, SSLCert and SSLAcceptServerCert to appropriate values.

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.

AuthMethodsControls how the task authenticates itself with the XMPP server.
ChatroomThe name of the chatroom to join.
ChatroomNicknameThe nickname to be used within the chatroom.
ChatroomPasswordThe password for the chatroom specified in the Chatroom configuration option.
FirewallA set of properties related to firewall access.
IMPortThe server port for XMPP (default 5222).
IMServerThis is the instant messaging server.
LogFileThe file to write logging information to at runtime.
LogModeWhat information gets logged during task execution.
MessageHTMLThis is the HTML version of the current message.
MessageOtherDataThis property contains extra data for the current message.
MessageSubjectThis is the subject of the current message.
MessageTextThis is the plain text of the current message.
MessageThreadThis is the thread name of the current message.
MessageTypeThis is the type of the current message.
OtherDefines a set of configuration settings to be used by the task.
PasswordThis is the user's password.
PersistentConnectionInstructs the task whether to keep the connection to the server open.
ResourceThis is the resource for the current session.
RuntimeLicenseSpecifies the task runtime license key.
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.
SSLStartModeDetermines how the task starts the SSL negotiation.
TimeoutA timeout for the task.
ToJIDA semicolon-separated list of destination nodes to receive the current message.
UserThe user portion of this entity's Jabber ID.

Configuration Settings

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

AuthDomainThe domain under which the user must authenticate.
DateTimeFormatThe DateTime format for the MessageReceivedTime message context property.
LogoffWhether or not to logoff from the server after execution.
ParseHTMLTells the task to parse MessageHTML into a plaintext representation.
ServerDomainThis is the domain of the XMPP service.
TreatMessageAsHTMLTells the task to treat the message contents as HTML.
UserDomainThe domain under which the user has registered with the XMPP service.
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]