O'Reilly logo

Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services by Régis Baccaro, Joost van Rossum

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required