Backup and Restore Operations - Microsoft SQL Server 2008 Analysis Services - page 793

SQL Server Integration Services

You can use SQL Server Integration Services (SSIS) to create a package that includes an
Analysis Services Execute DDL task to send a command to back up your databases.
First, create a new Integrations Services project in Business Intelligence Development
Studio and drag an Analysis Services Execute DDL task onto the Control Flow pane.
Then double-click your task and click General in the Analysis Services Execute DDL task
editor, as shown in Figure 39.3.

FIGURE 39.3

Use the Analysis Services Execute DDL task editor to get the DDL Statements

dialog box.

Enter a name for your task. Next, click DDL in the editor to create a new connection that
points to your Analysis Server. Leave SourceType as it appears ( Direct Input ). Click
SourceDirect and insert your Backup command into the DDL Statements box that
appears, as shown in Figure 39.4. To refresh your knowledge of the Backup command and
how to generate a backup script, see the “Using a DDL Command to Back Up Your
Database” section earlier in this chapter. Now you can debug your SSIS project to test
your backup package.