The Progress
tab of the Canvas shows how the task was executed, as shown in the
following screenshot. This includes the extended stored procedure as well
as the BACKUP DATABASE statements appropriately.
Package with Maintenance Plan Tasks
[ 296 ]
14. Browse to the location where you created the backup for review.
You will see a new file MyNwind.bak in the file location chosen as
shown below.
The backup file shows the name of the database as well as the date and time when it
was made.
"MyNorthwind_backup_20078311616.bak".
Summary
This chapter considered the Maintenance Plan tasks in general and in particular, one
of the options that you have in the Back Up Database Task. As mentioned, you have
another option in the SQL Server 2005 Management Studio for Maintenance Plan
tasks, if you have no access to the Business Intelligence via SSIS. The configuration
of the Maintenance Plan Tasks in SSIS is easy and quite straightforward and follows
similar wizard driven dialog windows.
Index
A
ActiveX Script task, SSIS
about 263, 264
adding 265-268
BI project, creating 265-268
new ActiveX Script task, adding to project
268-272
package, creating 264
Aggregate Data Transformation
about 147
adding 149
BI project, creating 149
configuring 150, 153
data flow task, adding 149
DataReader source, adding 149
DataReader source, configuring 149
DataReader source, connecting 150
package, executing 156, 157
path, establishing 150
Percentage Sampling data flow item,
configuring 154, 155
Percentage Sampling data transformation,
adding 153
Percentage Sampling data transformation,
path establishing to 153
project, building 156, 157
recordset destination data flow component,
adding 155
recordset destination data flow component,
configuring 155, 156
results, reviewing 156, 157
steps 149
used 148
B
BI project, SSIS
creating, for integration services 28-32
creating, Visual Studio 2005 used 28
Folders 67, 68
items in Options 66
items in Tools 66
Microsoft products used 27
package, executing 68
package design, canvas 37
project, saving 68
project window, overview 33-36
properties window 32
Property Pages window 67, 68
resources used 28
toolbox 44
Visual Studio 2005, launching 28-32
windows 53
Bulk Insert task
about 123
adding 126
BI project, creating 126
configuring 126-131
data transferring, from flat file to SQL
Server database table 123
error, handling 132
flat text file, creating 124
flat text file, using 124
package, executing 131
project, building 131
steps 124
table, creating 124, 125
Business Intelligence.
Pages:
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200