1.1 Glossary

This document uses the following terms:

bcp utility: A Microsoft SQL Server utility that bulk copies data in a user-specified format between an instance of SQL Server and a data file. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.

BSTR: A binary structure that contains a string. The structure consists of a length prefix, a character string, and a terminator character.

executable: A unit of executable code that performs a defined task along the data flow in a package.

expression: A combination of symbols (identifiers, literals, functions, and operators) that yields a single data value.

globally unique identifier (GUID): A term used interchangeably with universally unique identifier (UUID) in Microsoft protocol technical documents (TDs). Interchanging the usage of these terms does not imply or require a specific algorithm or mechanism to generate the value. Specifically, the use of this term does not imply or require that the algorithms described in [RFC4122] or [C706] must be used for generating the GUID. See also universally unique identifier (UUID).

indirect method: A method by which a configuration file is identified by having a Windows environment variable contain the path to the configuration file, instead of storing the path to the file within the package file itself.

inferred member: A member of an Analysis Services dimension whose existence can be inferred from a fact table but which has not yet been loaded from the dimension.

INI file: A configuration file that is used by Windows programs to initialize program settings.

inner variable: A DTS 2000 variable that is of package scope to a DTS 2000 Package when that package is executed by a parent Microsoft SQL Server Integration Services (SSIS) package. The inner variable is passed in to the DTS 2000 package from a parent Integration Services package.

language code identifier (LCID): A 32-bit number that identifies the user interface human language dialect or variation that is supported by an application or a client computer.

Microsoft Message Queuing (MSMQ): A communications service that provides asynchronous and reliable message passing between distributed applications. In Message Queuing, applications send messages to queues and consume messages from queues. The queues provide persistence of the messages, enabling the sending and receiving applications to operate asynchronously from one another.

outer variable: An Integration Services package-scope variable that is passed into a DTS 2000 package. Inside the DTS 2000 package, it becomes an inner variable.

package file: A file that contains a collection of tasks that form a workflow that is executed in the order that is defined within the package, with possible conditional branching.

package variable: A special type of variable within a package file that contains information about the last state of the screen layout of the package. Package variables are used by the user interface when a new session to modify a package is started.

passive mode: An FTP mode in which the client initiates a conversation by connection to the FTP server port, and the client also initiates the data communication port connection, to a port specified by the server in its initial response to the client. For more information about FTP active mode and passive mode, see [MSKB-323446].

precedence constraint: An object in a Integration Services package that controls the order of execution of tasks or the condition under which a task executes.

Server Management Objects (SMO) Server: An instance of SQL Server that is accessed through calls to the Server Management Objects (SMO) object model.

Simple Mail Transfer Protocol (SMTP): A member of the TCP/IP suite of protocols that is used to transport Internet messages, as described in [RFC5321].

tag table: A table that is used in the column pattern profile option of the Data Profiling Task. This table contains a list of tags that are used to tag specific terms that are found in the data file.

task: The building block of a package. A task consists of code that executes a function, as specified by the options, settings, and parameters of the task that are specified when the task is called.

TFIDF Score: One of the options for producing a similarity score used by the Term Extraction Component. The TFIDF score is defined as the TFIDF of a Term T = (frequency of T) * log( (# rows in Input) / (# rows having T) ).

Transact-SQL: The Microsoft proprietary version of SQL, the structured query language.

Unicode: A character encoding standard developed by the Unicode Consortium that represents almost all of the written languages of the world. The Unicode standard [UNICODE5.0.0/2007] provides three forms (UTF-8, UTF-16, and UTF-32) and seven schemes (UTF-8, UTF-16, UTF-16 BE, UTF-16 LE, UTF-32, UTF-32 LE, and UTF-32 BE).

universally unique identifier (UUID): A 128-bit value. UUIDs can be used for multiple purposes, from tagging objects with an extremely short lifetime, to reliably identifying very persistent objects in cross-process communication such as client and server interfaces, manager entry-point vectors, and RPC objects. UUIDs are highly likely to be unique. UUIDs are also known as globally unique identifiers (GUIDs) and these terms are used interchangeably in the Microsoft protocol technical documents (TDs). Interchanging the usage of these terms does not imply or require a specific algorithm or mechanism to generate the UUID. Specifically, the use of this term does not imply or require that the algorithms described in [RFC4122] or [C706] must be used for generating the UUID.

variable: One of the objects that is in a package file. A variable allows a package designer to assign a value to a symbolic name, which can then be accessed by other package objects.

Windows Management Instrumentation (WMI): The Microsoft implementation of Common Information Model (CIM), as specified in [DMTF-DSP0004]. WMI allows an administrator to manage local and remote machines and models computer and network objects using an extension of the CIM standard.

XPathNavigator: An object that allows navigation of the set of objects that are returned by an XPATH query.

MAY, SHOULD, MUST, SHOULD NOT, MUST NOT: These terms (in all caps) are used as defined in [RFC2119]. All statements of optional behavior use either MAY, SHOULD, or SHOULD NOT.