aspx). The following screenshot shows the type of
operations that the File System Task can carry out in SSIS.
Creating a SSIS Package to Access Folders and Files
[ 188 ]
In this chapter, in addition to using the File System Task, you will also learn about
Precedence Constraints, a programming construct necessary for ordering tasks in a
package. When there are a number of tasks, for the flow from one task to the other
to be smooth and free of problems, some ordering is needed. Like you have to apply
for a job before you get interviewed. You get hired only after the interview, etc. The
Precedence constraint in SSIS does the same with executables (For Loop, Task, Event
Handlers, etc.), containers, and tasks in packages.
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 Task
This process has been described a number of times in the previous chapters.
Pages:
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142