Despite the fact it is a contrived example, it illustrates the basic
ideas behind event handling in SSIS.
Package that Transfers a File
Using an FTP Task
FTP short for File Transfer Protocol is the best known for what it does??”it transfers
files in ASCII or other formats, over the Internet, even between disparate operating
systems with provisions for file storage. Please review RFC 765 for most of its
features. You can also use command line as well as proprietary software programs
to download / upload files using FTP.
FTP is one of the most common ways in which files (data, text, csv files, documents,
music, picture, etc.) are downloaded from websites. It is bidirectional and, therefore,
you can upload as easily as download. This computer-to-computer transfer of files
obviously will involve authentication. In the anonymous login mode, where the
download site allows anonymous logins, you normally do not provide a password
while the username is Anonymous. However, for other sites you may need to
be authenticated.
FTP task was also a part of the DTS, the Data Transformation Services available in
SQL 2000. You may review this article, http://www.aspfree.com/c/a/MS-SQLServer/
Using-Data-Transformation-Services-part-7-Transferring-Fileswith-
DTS/, if you want to know how the FTP task was handled in SQL 2000.
In this exercise, you will create a package that incorporates a FTP Task. In the first
example, you will be transferring a graphic file (GIF) from a location on your hard
drive to the local FTP server.
Pages:
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178