3. Also click on the Progress tab, which now appears in the Canvas by the side
of the Package Explorer to review how the execution started and completed.
If the package failed, this will also show the step at which the package failed.
4. Finally open up your Chapter4.txt file and verify that the table data is
transferred to the text file.
Only a part of the (four rows) data from this text file is shown in the
following screenshot.
Transferring Data to a Text File
[ 98 ]
Summary
This chapter described the configuration of data flow components that are necessary
for transferring data from a single table on the SQL Server 2005 to a pre-formatted
Flat File. The mappings between the columns of table to the text file must be correctly
carried out for successful transfer. The reverse of this transfer can be accomplished
by choosing a Flat File Source and an SQL Server Destination.
Transferring Data to a
Microsoft Excel File
This chapter shows you how to create a package that can transfer data from a table in
an SQL Server 2005 Server database to a Microsoft Excel Spreadsheet. You will also
learn how to use a Character Map Data Transformation. In the hands-on exercise,
you will be transferring data retrieved from an SQL 2005 table to MS Excel 2003
spreadsheet file. You will be using a Data Flow Task consisting of a source connected
to a SQL 2005 Server-based connection manager, as in the previous chapter, and an
Excel Destination connected to an Excel connection manager.
Pages:
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83