2. Change the default name of package from Package.dtsx to
TableToXls.dtsx.
3. Drag and drop a Data Flow Task from the Toolbox onto the Control
Flow page.
4. Click open the Data Flow tab, which displays the Data Flow page.
Now, you will be able to access the Data Flow Items of the Toolbox
consisting of Data Flow Sources, Data Flow Destinations, and Data Flow
Transformations (refer to Chapter 1).
5. Drag and drop a DataReader Source from the Data Flow Sources group
onto the Data Flow page.
Step 2: Configuring the DataReader's
Connection Manager
Configuring the DataReader source that connects to the local SQL Server 2005 has
been described in earlier chapters. Here, only a couple of the images relevant to this
chapter will be shown.
1. Right-click inside the Connection Managers page below the Canvas, and
from the drop-down choose New ADO.Net Connection??¦.
Chapter 5
[ 101 ]
If you are continuing with this chapter after Chapter 4, you will see the
Configure ADO.NET Connection Manager screen displaying the previously
configured connection manager. If you need to create a new one, follow the
steps shown in the previous chapter.
2. Click on the OK button in the Configure ADO.NET Connection
Manager window.
A connection manager, Localhost.MyNorthwind.sa, will be added to the
Connection Manager's page.
Step 3: Configuring the DataReader Source
1. Right-click the DataReader Source, in the drop-down menu.
2. Choose the Edit??¦ menu item in the drop-down menu.
Pages:
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85