SSAS Scripts 
SSIS Package to Back Up SSAS Databases by Dave Fackler
SSIS Package to Back Up SSAS Databases by Dave Fackler | SSIS Package to Back Up SSAS Databases by Dave Fackler |
| Written by Dave Fackler | ||||
| Thursday, 13 March 2008 20:04 | ||||
|
Author: Dave Fackler There are a couple of different posts and blog entries out there that discuss backing up SSAS databases using various techniques such as AMO, SSIS, etc. I recently created an SSIS package to do the same thing, and I think it's a little bit simpler than some of the other solutions out there. The basic design of the package is to use a ForEach Loop container to loop over the list of databases on a given SSAS server (versus using AMO or some other method of getting a list of databases) and then using an Analysis Services DDL task with an XMLA script that calls for a backup of the current database. Read more and download package here.
|
||||
Top Rated
- SSIS Package to drop and create partitions based on data in SQL Server table
- SSIS Package to Back Up SSAS Databases by Dave Fackler
- WSH script to get SSAS DB info about aggregation designs
- SSIS package to backup all Analysis Services databases on one instance
- SSIS Package to process all dimensions in one SSAS Database
