Books for you

The other tasks are as easy to configure.
Hands-On Exercise: Creating a Package with
Maintenance Tasks
1. Create a Business Intelligence Project Ch 20 and rename the default name of
the package.
The default name was changed to Maintain.dtsx in this exercise.
2. Drag and drop a Back Up Database Task from the Maintenance Plans Tasks
group, from the Toolbox onto the Control Flow page of the Canvas.
3. Right-click the Back Up Database Task and from the drop-down choose
Edit??¦ (or double-click the Back Up Database Task component).
Package with Maintenance Plan Tasks
[ 290 ]
This brings up the Back Up Database Task editor window.
Chapter 20
[ 291 ]
4. Click on the New... button along the label, Connection.
This opens the New Connection window, as shown below, displaying the local
server by "." in the text box below the label, Select or enter a server name.
5. Type in a name for the connection.
Package with Maintenance Plan Tasks
[ 292 ]
Here, it is named "Backing Up MyNwnd" by typing this into the text box
below the label Connection name. The authentication will be by SQL Server
authentication. Enter the details, as shown, in the next screen.
This enables the Databases drop-down list box control, displaying
.
Chapter 20
[ 293 ]
6. Click on this drop-down and select MyNorthwind, as shown in the
following screenshot.
Of course, you can choose the other databases as well if needed.
7. Click on the OK button after making the choice.


Pages:
180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200

CNET Do-It-Yourself Home Networking Projects (page 116) The Adventure Club Afloat (page 231) Business Intelligence with Microsoft Office PerformancePoint Server 2007 (page 4014)