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.