Jabber Task

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Join VIP ----- Questions?

Overview

The Jabber Task is an SSIS Control Flow task for interaction with Jabber/XMPP clients.


Setup

Use the General page of the Jabber Task Editor dialog to configure the parameters needed to communicate with a client.

Options

Name

Specify the task name.

Description

Specify the task description.

Action

Specify the task action. This parameter has the options listed in the following table.

Option Description
Send message Sends a message. Selecting this action displays the dynamic parameters Type, IsRecipientVariable, Recipient, RecipientVariable, Thread, IsSubjectVariable, Subject, SubjectVariable, IsBodyVariable, Body, BodyVariable, IsHtmlVariable, Html, HtmlVariable.
Receive message Receives a message. Selecting this action displays the dynamic parameters ResultVariable, IsSenderVariable, Sender, SenderVariable, Timeout.
JabberConnection

Selects an existing Jabber connection manager, or click <New connection...> to create a new connection manager.

Related Topics: Jabber Connection Manager

Type

Specify the type of message to send. This parameter has the options listed in the following table.

Option Description
Normal Normal message.
Chat Chat (one-on-one) message.
Group chat Group chat message.
Headline Headline message.
Error Error message.

IsRecipientVariable

Indicate whether or not the recipient(s) are stored in a variable. This parameter has the options listed in the following table.

Option Description
True The recipient is stored in a variable. Selecting this option displays the dynamic parameter RecipientVariable.
False The recipient is specified. Selecting this option displays the dynamic parameter Recipient.
Recipient

Type in the recipient or select from the Jabber server roster list. Separate multiple recipients with a semicolon (;).

RecipientVariable

Select an existing user-defined variable, or click <New variable...> to create a new variable.

Related Topics: Integration Services Variables, Add Variable

Thread

Specify a message thread.

IsSubjectVariable

Indicate whether or not the message subject is stored in a variable. This parameter has the options listed in the following table.

Option Description
True The message subject is stored in a variable. Selecting this option displays the dynamic parameter SubjectVariable.
False The message subject is specified. Selecting this option displays the dynamic parameter Subject.
Subject

Specify the message subject.

SubjectVariable

Select an existing user-defined variable, or click <New variable...> to create a new variable.

Related Topics: Integration Services Variables, Add Variable

IsBodyVariable

Indicate whether or not the message body is stored in a variable. This parameter has the options listed in the following table.

Option Description
True The message body is stored in a variable. Selecting this option displays the dynamic parameter BodyVariable.
False The message body is specified. Selecting this option displays the dynamic parameter Body.
Body

Specify the message body.

BodyVariable

Selects an existing user-defined variable, or click <New variable...> to create a new variable.

Related Topics: Integration Services Variables, Add Variable

IsHtmlVariable

Indicate whether or not the message HTML text is stored in a variable. This parameter has the options listed in the following table.

Option Description
True The message HTML text is stored in a variable. Selecting this option displays the dynamic parameter HtmlVariable.
False The message HTML text is specified. Selecting this option displays the dynamic parameter Html.
Html

Specify message HTML text.

HtmlVariable

Select an existing user-defined variable, or click <New variable...> to create a new variable.

Related Topics: Integration Services Variables, Add Variable

ResultVariable

Select an existing user-defined variable, or click <New variable...> to create a new variable.

Related Topics: Integration Services Variables, Add Variable

IsSenderVariable

Indicate whether or not the message sender(s) are stored in a variable. This parameter has the options listed in the following table.

Option Description
True The message sender is stored in a variable. Selecting this option displays the dynamic parameter SenderVariable.
False The message sender is specified. Selecting this option displays the dynamic parameter Sender.
Sender

Optional. This parameter is used to define the senders from whom messages will be accepted. If a sender is not in the list, messages will not be accepted from them. Type in the sender or select from the Jabber server roster list. Separate multiple senders with a semicolon (;).

SenderVariable

Select an existing user-defined variable, or click <New variable...> to create a new variable.

Related Topics: Integration Services Variables, Add Variable

Timeout

Specify maximum time in seconds to wait for a message to arrive. The default value of this parameter is 3600 (1 hour).