CHAPTER 6

image

Working Through the Internet and the Web

The Web is an important source for data. Data might come from files that are located on a web site or on an (S)FTP server. In this chapter, you learn how to work with files through the Web, how to download files, and how to work with FTP and SFTP. Scenarios in this chapter cannot be done easily with built-in tasks, such as the FTP Task.

Sending HTML-Formatted Email

One of the drawbacks of the out-of-the-box Send Mail Task is that it doesn’t support HTML-formatted emails. The associated SMTP Connection Manager doesn’t support more-advanced settings like changing port and setting basic credentials. ...

Get Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.