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: Copying a File from One Folder to Another and Sending it using the Send Mail Task

In this exercise, we will use the File System Task to copy an ASCII file from one folder to another folder using the CopyFile operation. When this task succeeds, we will email this using the Send Mail Task, a task we studied in an earlier chapter.

In completing this exercise, you will be carrying out these major steps:

  • Creating a BI Project and adding a Control Flow Task—the File System Task.

  • Configuring the File System Task.

  • Adding a Send Mail Task to the Control Flow page on the Canvas.

  • Adding a Precedence Constraint.

  • Building and Executing the package.

Step 1: Creating a BI Project and Adding a Control Flow Task — the File System ...

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