Database Reference
In-Depth Information
5.
For the Package Path textbox, click the ellipsis button, browse to the file
C:\_BookFiles\Chapter02Files\_SSISFiles\LoadDWWeatherTracker.dtsx
, and
click Open. Then click the OK button to close the dialog window and have visual Studio
copy the
.dtsx
file to your SSiS project. The file should now appear in Solution Explorer.
6.
Once the file is added, verify in the visual Studio Properties window that the package
file was copied from the proper file. (if you do not see the Properties window,
you can open it by right-clicking
LoadDWWeatherTracker.dtsx
and selecting
Properties.) The path should show the
_BISolutions\...
path (not
_BookFiles
).
Verify the Connections
whenever you are working with someone else's SSiS package, there is a chance that the SQL server
instance name on their computer is not the same as the one on your computer. At this point, we need to
make sure that the connections are correct for your computer by opening and editing the package.
1.
To open and edit the package, double-click the
LoadDWWeatherTracker.dtsx
package file in Solution Explorer or right-click the file and choose Open from the
context menu. The package opens, and the Control Flow tab displays the four tasks
shown in Figure
2-29
.
2.
Locate the two connections under the Connection Manager tab at the bottom of
visual Studio, as shown in Figure
2-30
.
3.
Right-click the connection called (local).DwweatherTracker (Figure
2-42
), and
uncheck the work Offline option from the context menu, as needed.
Figure 2-42.
Unchecking the Work Offline option
