Quite often when performing a demo, teaching, or building SSIS Packages I am using either SMTP, IMAP or POP3 connection information. Each time I have to find my own local document that has this information stored or I have to search the web, so I’ve decided to post the information here for my own convenience and perhaps yours as well!

If you have some providers you would like to add to this just email me at mpearson@pragmaticworks.com Thanks!

Note: Task Factory by Pragmatic Works offers three separate email tasks for use in SSIS. If you are interested you can learn more about Task Factory here: http://pragmaticworks.com/Products/Task-Factory

Yahoo Configuration Settings

SMTP

• Mail Server:     smtp.yahoo.mail.com
• Port:                465
• Encryption:      SSL

IMAP

• Mail Server:    Imap.mail.yahoo.com
• Port:               993
• TLS/SSL:       Yes

POP3

• Mail Server:     pop.mail.yahoo.com
• Port:                995
• Encryption:     SSL

Gmail Configuration Settings

SMTP

• Mail Server:      smtp.gmail.com
• Port:                 587
• Encryption:       TSL

Office 365 Configuration Settings

SMTP

• Server name:     smtp.office365.com
• Port:                  587
• Encryption:        TLS

IMAP

• Server name:    outlook.office365.com
• Port:                 993
• Encryption:      SSL

POP3

• Server name:   outlook.office365.com
• Port:                995
• Encryption:      SSL