WHAT'S HOT
Prev | Current Page 167 | Next

Jayaram Krishnaswamy

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

In the second example, you will be downloading a
non-ASCII file over the Internet from a site that allows anonymous logins.
Package that Transfers a File Using an FTP Task
[ 252 ]
Hands-On Exercise: Creating a Package
with a FTP Task
In example 1, you will be transferring a text file on the C:\ drive to the root folder of
your local FTP server. In IIS 5.1, the version of Internet Information Services program
on this machine, the FTP services are also handled by the IIS, as shown in this
default view. For the example shown in this exercise to work, you must have the FTP
services enabled. This can be enabled through following, Start |Control Panel|Add
or Remove Programs. Then, you need to bring up the Add / Remove Windows
components. In the Windows Components Wizard, you must enable the Internet
Information Services check box.
For this server, anonymous authentication has been enabled and users can login
without a password. When you browse the site (ftp://yoursite), you will be able
to see the directory of this site, as shown in the following screenshot. You may also
browse using the IP address instead of the computer name. As you can see, this
service is not very much utilized on this computer.
Chapter 17
[ 253 ]
In example 2, you will be accessing a site that is public and does not require
authentication. We will access the FTP site, ftp:\\archive.orst.edu, and
download some documents from there.
The following steps will be described in setting up a BI project with an FTP task:
Create a BI project and rename the default package.


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