WHAT'S HOT
Prev | Current Page 170 | Next

Jayaram Krishnaswamy

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


This inserts "/" for the line item RemotePath in the FTP Task Editor.
10. Now click on the point 2 along the line item LocalPath in the FTP Task
Editor and from the drop-down click on
This brings up the File Connection Manager Editor's window that you have
seen in earlier chapters.
11. Using the Browse button, look through the hard drive and choose the file
(any file of your choice will do) to be transferred.
For this exercise, the graphic file daruma.gif, from the hard drive, was
chosen, as shown in the following screenshot. The IsTransferAscii set to
false (default) is appropriate.
Chapter 17
[ 257 ]
12. Click on the OK button in the above window to complete the File Transfer
Task Editor items.
Step 2: Build and Execute the FTP Task
1. Build the project and execute the task or project as done in the previous
chapters.
The program begins to run and the FTP Task component turns green
indicating a successful execution.
2. Open the Internet Information Services application and browse the Default
FTP Site.
You will find that the daruma.gif has been transferred (uploaded) to your
FTP server.
Step 3: Disable the FTP Task, Add and
Configure another FTP Task to Download
a File from an Internet Public Site
1. Disable the Transfer File Task component on the Canvas by right-clicking
the component and choosing Disable. It is not really necessary as each task
can be executed independent of the other. This is just to keep an eye on the
component to be executed.


Pages:
158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182