nSoftware have released a quite of tools for SSIS called IPWorks. It all builds on their previous work building adapters for BizTalk applications - the like of which my colleague Jack Hanison has been using on his BizTalk implementations.
Here's a very quick synopsis of what they provide:
- DNS - query DNS for information
- FileMailer - send emails with attachments
- FTP - Standard FTP client. Includes features (e.g. Directory Listings) and allows configuration over and above the standard FTP task provided with SSIS
- HTMLMailer - Send html mail
HTTP - Issue HTTP Get, Post & Put operations - IMAP - IMAP Client
- IPInfo - Resolve hostnames to addresses and vice versa
- LDAP - Communicate with LDAP Directory Servers using Lightweight Directory Access Protocol (LDAP)
- MIME - Implements Multipurpose Intenet Mail Extensions (MIME) for formatting of messages
- NetClock - Gets current CMT time from an internet time server
- NetCode - Encode/Decode files and strings using UUEncode or hash functions such as MD5 and SHA1
- NNTP - Read/Post messages on Usenet
- Ping - Ping a remote machine
- POP - Receive email from POP3 servers
- RExec - Remote execution of UNIX commands
- RSS - Retrieve, Parse, Write RSS content
- SFTP - Secure FTP Task
- SMPP - Send text messages from SSIS. A good alternative to sending mail, assuming you have an SMPP server
- SMTP - Send mail over SMTP
SNPP - Send pages (i.e. to a person's pager) over the internet using SNPP - TraceRoute - trace the route of IP packaets on the internet
- WebDAV - An interface to Web Distributed Authoring and Versioning protocol (WebDAV).
- WebForm - Commit an HTML POST, similar to what HTML forms do
- WebUpload - Upload tasks to RFC1867-compliant web servers
- Whois - Query a WHOIS server
- XMPP - Lightweight messaging client using the Jabber protocol
I'm slightly skeptical as to the usefulness of some of that stuff in a SSIS application but in the main there's some really useful stuff there such as FTP, Ping, SMTP, SMPP, RSS & RExec to name but a few.
Well worth checking out if these type of operations are important to you.
-Jamie