Build and execute the FTP task.
Disable the FTP task, add and configure another FTP task to download a file
from an Internet public site.
Build and execute the new FTP task.
Step 1: Creat a BI Project and Rename the
Default Package
This process has been described a number of times in various chapters.
1. Create a Business Intelligence Project Ch 17 and rename the default name of
the package.
The default name was changed to ftp.dtsx in this exercise.
2. Drag and drop an FTP Task from the Control Flow Items group, from the
Toolbox, onto the Control Flow page of the Canvas.
3. Right-click the FTP Task, and from the drop-down choose Edit??¦
(or double-click the FTP Task component).
??? ??? ??? ???
Package that Transfers a File Using an FTP Task
[ 254 ]
This opens the FTP Task Editor window, as shown in the following
screenshot. (The location shown as 1 is added after the window is open.)
In this window, open with the General list item; you need to provide
information regarding the FTP Connection as well as a Name and
Description of your choice.
In this exercise, the Name chosen was "Transfer File Task" and the
Description was "FTP file to root folder".
4. Click on the location shown by 1 in the above window along the line item
FtpConnection, and from the drop-down choose
.
This opens up the FTP Connection Manager Editor window.
Chapter 17
[ 255 ]
As mentioned earlier, you need to provide a name for the FTP Server in the
line item, Server name.
Pages:
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180