SSIS Components for Microsoft Exchange

Build 24.0.9060

Contacts

Create, update, delete, and query Contacts items.

Table Specific Information

Update and Delete

The component will need the ItemChangeKey to update or delete an item. However, if you are unsure of the ItemChangeKey, the component is able to retrieve it from the Exchange server automatically. Note that this may increase the time it takes to perform a query.

Columns

Name Type ReadOnly Description
ItemId [KEY] String True

Contains the unique identifier of an item in the Exchange store. This property is read-only.

MimeContent String True

Contains the native Multipurpose Internet Mail Extensions (MIME) stream of an object that is represented in Base64 binary format.

ItemChangeKey String True

Contains the unique change key of an item in the Exchange store. This property is read-only.

ParentFolderId String False

Represents the unique identifier of the parent folder that contains the item or folder. This property is read-only.

ParentFolderChangeKey String True

Represents the unique change key of the parent folder that contains the item or folder. This property is read-only.

ItemClass String False

Represents the message class of an item.

Subject String False

Represents the subject for Exchange store items and response objects. The subject is limited to 255 characters.

Sensitivity String True

Indicates the sensitivity level of an item.

Body String False

Represents the actual body content of a message.

DateTimeReceived Datetime True

Represents the date and time that an item in a mailbox was received.

Size Integer True

Represents the size in bytes of an item. This property is read-only.

Categories String False

Represents a collection of strings that identify to which categories an item in the mailbox belongs.

Importance String False

Describes the importance of an item.

IsSubmitted Boolean True

Indicates whether an item has been submitted to the Outbox default folder.

InReplyTo String True

Represents the identifier of the item to which this item is a reply.

IsDraft Boolean True

Represents whether an item has not yet been sent.

IsFromMe Boolean True

Indicates whether a user sent an item to himself or herself.

IsResend Boolean True

Indicates whether the item had previously been sent.

IsUnmodified Boolean True

Indicates whether the item has been modified.

InternetMessageHeaders String True

Represents the collection of all Internet message headers that are contained within an item in a mailbox.

DateTimeSent Datetime True

Represents the date and time that an item in a mailbox was sent.

DateTimeCreated Datetime True

Represents the date and time that a given item in the mailbox was created.

ReminderDueBy Datetime False

Represents the date and time when the event occurs.

ReminderIsSet Boolean False

Indicates whether a reminder has been set for an item in the Exchange store.

ReminderMinutesBeforeStart Integer False

Represents the number of minutes before an event occurs when a reminder is displayed.

DisplayCc String True

Represents the display string that is used for the contents of the Cc box. This is the concatenated string of all Cc recipient display names.

DisplayTo String True

Represents the display string that is used for the contents of the To box. This is the concatenated string of all To recipient display names.

HasAttachments Boolean True

Represents a property that is set to true if an item has at least one visible attachment. This property is read-only.

Culture String False

Represents the culture for a given item in a mailbox.

EffectiveRights_CreateAssociated Boolean True

Indicates whether a client can create an associated contents table.

EffectiveRights_CreateContents Boolean True

Indicates whether a client can create a contents table.

EffectiveRights_CreateHierarchy Boolean True

Indicates whether a client can create a hierarchy table.

EffectiveRights_Delete Boolean True

Indicates whether a client can delete a folder or item.

EffectiveRights_Modify Boolean True

Indicates whether a client can modify a folder or item.

EffectiveRights_Read Boolean True

Indicates whether a client can read a folder or item.

EffectiveRights_ViewPrivateItems Boolean True

Indicates whether a private item can be viewed.

LastModifiedName String True

Contains the display name of the last user to modify an item.

LastModifiedTime Datetime True

Indicates when an item was last modified. This element is read-only.

IsAssociated Boolean False

Indicates whether the item is associated with a folder.

WebClientReadFormQueryString String True

Represents a URL to concatenate to the Microsoft Office Outlook Web App endpoint to read an item in Outlook Web App.

WebClientEditFormQueryString String True

Represents a URL to concatenate to the Outlook Web App endpoint to edit an item in Outlook Web App.

ConversationId String True

Identifies a specific conversation in the Exchange store.

UniqueBody String True

Represents an HTML fragment or plain-text which represents the unique body of this conversation.

UniqueBodyType String True

Describes how the unique item body is stored in the item (HTML or TEXT).

FileAs String False

Represents how a contact or distribution list is filed in the Contacts folder.

FileAsMapping String False

Defines how to construct what is displayed for a contact.

DisplayName String False

Defines the display name of a folder, contact, distribution list, delegate user, location, or rule.

GivenName String False

Contains the given name of a contact.

Initials String False

Represents the initials of a contact.

MiddleName String False

Represents the middle name of a contact.

Nickname String False

Represents the nickname of a contact.

CompleteName_Title String True

Represents the title of a contact.

CompleteName_FirstName String True

Represents the first name of a contact.

CompleteName_MiddleName String True

Represents the middle name of a contact.

CompleteName_LastName String True

Represents the last name of a contact.

CompleteName_Suffix String True

Represents the suffix of a contact.

CompleteName_Initials String True

Represents the initials of a contact.

CompleteName_FullName String True

Represents the full name of a contact.

CompleteName_Nickname String True

Represents the nickname of a contact.

CompleteName_YomiFirstName String True

Represents the name used in Japan for the searchable or phonetic spelling of a Japanese first name.

CompleteName_YomiLastName String True

Represents the name used in Japan for the searchable or phonetic spelling of a Japanese first name.

CompanyName String False

Represents the company name that is associated with a contact.

EmailAddress1 String False

Represents a single email address for a contact.

EmailAddress2 String False

Represents a single email address for a contact.

EmailAddress3 String False

Represents a single email address for a contact.

BusinessAddress_Street String False

Represents the Business street address for a contact item.

BusinessAddress_City String False

Represents the Business city name for a contact item.

BusinessAddress_State String False

Represents the Business state of residence for a contact item.

BusinessAddress_Country String False

Represents the Business country or region for a contact item.

BusinessAddress_PostalCode String False

Represents the Business postal code for a contact item.

HomeAddress_Street String False

Represents the Home street address for a contact item.

HomeAddress_City String False

Represents the Home city name for a contact item.

HomeAddress_State String False

Represents the Home state of residence for a contact item.

HomeAddress_Country String False

Represents the Home country or region for a contact item.

HomeAddress_PostalCode String False

Represents the Home postal code for a contact item.

OtherAddress_Street String False

Represents the Other street address for a contact item.

OtherAddress_City String False

Represents the Other city name for a contact item.

OtherAddress_State String False

Represents the Other state of residence for a contact item.

OtherAddress_Country String False

Represents the Other country or region for a contact item.

OtherAddress_PostalCode String False

Represents the Other postal code for a contact item.

AssistantPhone String False

Represents the AssistantPhone number for a contact item.

BusinessFax String False

Represents the BusinessFax number for a contact item.

BusinessPhone String False

Represents the BusinessPhone number for a contact item.

BusinessPhone2 String False

Represents the BusinessPhone2 number for a contact item.

Callback String False

Represents the Callback number for a contact item.

CarPhone String False

Represents the CarPhone number for a contact item.

CompanyMainPhone String False

Represents the CompanyMainPhone number for a contact item.

HomeFax String False

Represents the HomeFax number for a contact item.

HomePhone String False

Represents the HomePhone number for a contact item.

HomePhone2 String False

Represents the HomePhone2 number for a contact item.

Isdn String False

Represents the Isdn number for a contact item.

MobilePhone String False

Represents the MobilePhone number for a contact item.

OtherFax String False

Represents the OtherFax number for a contact item.

OtherTelephone String False

Represents the OtherTelephone number for a contact item.

Pager String False

Represents the Pager number for a contact item.

PrimaryPhone String False

Represents the PrimaryPhone number for a contact item.

RadioPhone String False

Represents the RadioPhone number for a contact item.

Telex String False

Represents the Telex number for a contact item.

TtyTddPhone String False

Represents the TtyTddPhone number for a contact item.

AssistantName String False

Represents an assistant to a contact.

Birthday Datetime False

Represents the birth date of a contact.

BusinessHomePage String False

Represents the Home page (Web address) for the contact.

Children_1 String False

Contains the name of the child of a contact.

Children_2 String False

Contains the name of the child of a contact.

Children_3 String False

Contains the name of the child of a contact.

Companies_1 String False

Represents the name of a company associated with a contact.

Companies_2 String False

Represents the name of a company associated with a contact.

Companies_3 String False

Represents the name of a company associated with a contact.

ContactSource String False

Describes whether the contact is located in the Exchange store or Active Directory Domain Services.

Department String False

Represents the department of a contact.

Generation String False

Represents a generational abbreviation that follows the full name of a contact.

ImAddress1 String False

Represents an instant messaging (IM) address for a contact.

ImAddress2 String False

Represents an instant messaging (IM) address for a contact.

ImAddress3 String False

Represents an instant messaging (IM) address for a contact.

JobTitle String False

Represents the job title of a contact.

Manager String False

Represents the manager of a contact.

Mileage String False

Represents the mileage for a contact item.

OfficeLocation String False

Represents the office location of a contact.

PostalAddressIndex String False

Represents the display type for the physical address of a contact.

Profession String False

Represents the profession of a contact.

SpouseName String False

Represents the name of the spouse or partner of the contact.

Surname String False

Represents the surname of a contact.

WeddingAnniversary Datetime False

Contains the wedding anniversary of a contact.

HasPicture Boolean False

Indicates whether the contact item has a file attachment that represents the picture of a contact.

PhoneticFullName String False

Contains the full name of a contact, including the first and last name, spelled phonetically.

PhoneticFirstName String False

Contains the first name of a contact, spelled phonetically.

PhoneticLastName String False

Contains the last name of a contact, spelled phonetically.

Alias String False

Contains the email alias of a contact.

Notes String False

Contains supplementary contact information.

Photo String False

Contains a value that encodes the photo of a contact.

UserSMIMECertificate String False

Contains a value that encodes the SMIME certificate of a contact.

MSExchangeCertificate String False

Contains a value that encodes the Microsoft Exchange certificate of a contact.

DirectoryId String False

Contains the directory Id of a contact.

ManagerMailbox String False

Contains SMTP information that identifies the mailbox of the manager of a contact.

DirectReports String False

Contains SMTP information that identifies the direct reports of a contact.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ImpersonationUser String

The Identifier of the user to impersonate.

ImpersonationType String

The type of Identifier used for the impersonation user (PrincipalName, SID, PrimarySmtpAddress, SmtpAddress).

SharedMailboxEmail String

The email of a shared mailbox. Use this to retrieve the contacts of a shared mailbox.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060