You also need to establish a path
connecting them.
Transferring Data to a Text File
[ 88 ]
Step 1: Creating a BI Project and Adding a
Data Flow Task
1. Create a business intelligence project Ch 4 as described in Chapter 2.
2. Change the default name of the package to TableToText.dtsx. Drag and
drop a Data Flow Task from the Toolbox on to the Control Flow page.
3. Click the Data Flow tab that 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). Drag and Drop a DataReader Source
from Data Flow Sources group onto the Data Flow page.
Step 2: Adding Connection Manager for
the DataReader
The DataReader Source connects to the SQL Server 2005 using the connection
properties defined in a connection manager.
1. Right-click inside the page of the Connection Managers (below the
DataFlow page) and from the drop-down list of new connections, choose
New ADO.NET Connection??¦.
This opens the Configure ADO.NET Connection Manager wizard, as shown
in the following screenshot.
Chapter 4
[ 89 ]
If there is no configured connection manager, the Data Connections: area
will be empty.
2. Click on the button, New??¦.
This opens the Connection Manager window, shown in the following screenshot,
where you will supply information required to get data from the SQL
2005 Server. All the fields (boxes) will be empty except for the Provider: field,
which displays a SqlClient Data Provider.
Pages:
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76