emailarms.com/downloads/1st_smtp.html) SMTP servers on the
Internet. If you are faced with connectivity problems for the SMTP server, you can
use the Telnet program (http://www.microsoft.com/resources/documentation/
windows/xp/all/proddocs/en-us/telnet_commands.mspx?mfr=true) and try to
connect to port 25 or 587, if successful verifies connectivity.
Transferring Data to
a Text File
This chapter shows you how to create a package that can transfer data from a table in
an SQL 2005 Server database to a Flat File on the C:\ drive of your computer.
Flat file data storage predates relational databases. Every detail about a record
consisting of a number of data fields is stored flat, in just one line in the file. Each
data field is separated from the other by some kind of field separator, such as a tab,
white space or a comma. There are no relationships between the fields in flat files.
Flat files are sometimes needed to obtain a simple text-based version of data that
can be transferred more easily between operating systems than data in a table. In the
hands-on exercise, you will be transferring data retrieved from an SQL Server 2005
table to a flat file. You will be using a Data Flow task consisting of a source connected
to an SQL Server 2005 based connection manager and a destination connected to a
Flat File connection manager.
Hands-On Exercise: Transferring Data to
a Text File
In order to follow the steps as indicated, you will need a source and a destination;
the source data will be coming from SQL Server 2005, and the destination would
be writing this to a flat file on your hard drive.
Pages:
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75