Integration Services - Professional SQL Server Analysis Services 2005 with MDX - page 847

10. Select the source type as File Connection. Select the drop-down list
under Source and select New Connection. In the File Connection
manager dialog, select the DDL file provided under the Chapter 16
directory on the Web site. The contents of the DDL are shown below.
This DDL will take a backup of the Analysis Services 2005 Tutorial
database.
<Backup xmlns="http://schemas.microsoft.com/
analysisservices/2003/engine">
<Object>
<DatabaseID>AnalysisServices2005Tutorial</DatabaseID>
</Object>
<File>AnalysisServices2005Tutorial.abf</File>
</Backup>
11. Once you have specified all the properties for the Execute DDL Task
editor as shown in Figure 16-6 , click OK.
If you run the SSIS package you have created a backup of the Analysis Ser-
vices 2005 Tutorial database will be created in Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Backup. Backup is usually an operation scheduled
for when the load on Analysis Services is minimal. Many companies do
backup operations on a nightly basis, but if you are a multinational company
or have customers using the database across the globe, you would have to
factor in your customers' needs and take the backup at an appropriate time.
Regardless of when the package is run, you want to know whether the opera-
tion succeeded or failed. Obviously you can check the logs on Analysis Ser-
vices or the logs of the SSIS package, but as an administrator one of the
easiest ways is to send an e-mail about the results of the operation. To facilit-
ate this operation, SSIS provides a task called the Send Mail Task. By spe-
cifying appropriate parameters to this task you can send an e-mail upon com-
pletion of a specific task or an entire SSIS package.
To add the send mail task to your SSIS package, drag and drop two instances
of Send Mail Task to your designer. You will use one task to send an e-mail
when the Execute DDL task succeeds and the other one to send mail when
the Execute DDL task fails. Now that you have two send mail tasks in the