WHAT'S HOT
Prev | Current Page 171 | Next

Jayaram Krishnaswamy

"Beginners Guide to SQL Server Integration Services Using Visual Studio 2005"


This will gray out the component.
2. Drag and drop a FTP Task component (from the Control Flow Items group)
from the Toolbox onto the Control Flow page of the Canvas.
Package that Transfers a File Using an FTP Task
[ 258 ]
3. Double-click the component and make changes to the General list item page
of the FTP Task Editor. For FtpConnection use the connection information
as shown in the following screenshot.
You will be using the host part of the URL for the Server name. Details
regarding FTP URL format is described in this article: http://tools.ietf.
org/html/draft-casey-url-ftp-00. You may recall that in the previous
task, which was disabled, we used the hierarchical symbol "/" for the
top level.
In this example, the Name of the task is "Download from FTP site" and the
Description is "Download a non-ASCII file from Internet". It can be any
Name and Description you choose.
Chapter 17
[ 259 ]
4. Click on the File Transfer list item. As it is a download operation, change
Send files (default) to Receive files from the drop-down, as shown in the
following screenshot.
5. Follow this by a click along the line item RemotePath to browse the site. This
opens the Browse for Directory window shown earlier.
6. Click on the pub folder to go down to the pub directory, and dig further, as
shown in the following screenshot.
Package that Transfers a File Using an FTP Task
[ 260 ]
7. The file in the mozilla-video folder in the above directory contains the file we
would like to download, as shown in the following screenshot.


Pages:
159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183
reklama biaƂystok Master Blaster Miami Sound Machine Los Del Rio Alanis Morissette