1. Create a BI project Ch 12. Change the name of the default package name to
FileSystemTsk.dtsx. Drag and drop a File System Task from the Control
Flow Items group in the Toolbox to the Control Flow page on the Canvas.
An instance of the File System Task will be added to the Canvas to the
Control Flow page.
??? ??? ??? ??? ???
Chapter 12
[ 189 ]
Step 2: Configuring The File System Task
1. Right-click the File System Task component on the Canvas and from the
drop-down menu choose Edit??¦.
This brings up the File System Task Editor window as shown in the next
screenshot. In the previous screenshot, we saw several operations possible
with this task. CopyFile operation appears by default when this editor opens.
Creating a SSIS Package to Access Folders and Files
[ 190 ]
We need to indicate the source file and its location as well as the destination location
to which this file will be copied. File System Task would interact with the file system
through connection managers that you can designate at design time, as we saw in
Chapter 11. We use exactly the same procedure to locate the file to be copied. The file
we are going to use is ThePrince.txt located on the C:\ drive, a copy of which is
shown in the following screenshot. The reader may use his/her own text file instead
of the previous file.
2. Click on a point shown by 1 in the line item SourceConnection.
A drop-down handle develops.
3. Click on the drop-down and choose
This opens the File Connection Manager Editor with the default Usage
Type: as Existing file.
Pages:
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143