O'Reilly logo

SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy

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

Hands-On Exercise One: Sending an Email Using the SMTP Server

For this exercise, you need to know the SMTP server that you can use for configuring this task. You may also use the SMTP server of your web mail program.

  1. 1. Create a New BI project Ch 3 from the File menu using the drop-down item, New, as described in Chapter 2.

  2. 2. In the Solution Explorer, right-click Package.dtsx and from the drop-down menu choose the option Rename and change it to Email. Do not change the extension; it should remain dtsx (i.e., Email.dtsx).

  3. 3. You will see a Microsoft Visual Studio warning. Click on the Yes button on the window with the warning.

    The package name changes in the Solution Explorer, as shown in the following screenshot, and the package properties are ...

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