SSIS Components for Email

Build 24.0.9060

POP

POP Specific Information

Email address fields contained within this table accept the following formats:

SELECT

Email will be listed newest to oldest. By default, the MessageBody and Headers will not be returned when listing multiple messages.

Note: By default, the max number of emails returned will be 100. This can be changed by setting either LIMIT or MaxItems. If you wish to return all emails, you will need to specify a value of 0 or -1.

List Emails

To list messages, simply call SELECT after specifying the account information. This will list the most recent messages first.

To specify a single Id, which will return headers and the message body, you can specify the following:

WHERE Id='10' //For returning only the message with an Id of 10.

To list messages beginning with a specific Id, you can set the StartId property in the WHERE clause. This will cause messages to begin with the Id you specified, to the oldest message available within the LIMIT.

WHERE StartId='45' //Returns messages 45 through 1
Search Emails

Searching is not supported by the POP protocol. In order to search emails, you must use IMAP.

INSERT

Please refer to the SMTP section.

UPDATE

Updating is not supported by the POP protocol.

Additional notes

By default, the number of messages returned per page will be 25. To change this, you can set the ItemsPerPage pseudo column.

All message Ids returned are temporary Ids and may change in subsequent requests to the server. To use static Ids, you can set UIDMode=true. However, only listing messages is supported with UIDs.

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