Database Reference
In-Depth Information
4.
Double-click the first connection called (local).DwweatherTracker (Figure
2-42
).
5.
when the Connection Manager dialog window appears, click the test connection button
at the bottom of the window to verify that you can connect to the data warehouse
database. A window will open with the text Test Connection Succeeded (Figure
2-32
).
if this does not occur, change the name of the server in the Server Name dropdown
box to match the name of your SQL server installation and try the test button again.
Important:
You do not need or want to change the SSiS connect name even if you change the SQL Server
name.
6.
Double-click the second connection called weatherHistoryTextFile. when the Flat File
Connection Manager editing window appears, verify that the file name is pointing
to the
C:\_BISolutions\WeatherTrackerProjects\WeatherHistory.txt
text file (Figure
2-31
).
7.
Click the Preview page on the left side of the dialog window. After verifying that the
data looks like Figure
2-43
, click OK to close it.
Figure 2-43.
Verifying the file connection
Important:
if the file connection does not work, please check that you correctly placed the
_BISolutions
folder
on the
C:\
drive. (You can review Exercise 2-1 for more information.) Click the Data Flow tab at the top of your
