Cool little package, thanks! NOTE: T

Cool little package, thanks! NOTE: The script in the package doesn't seem to work on a 64-bit 2005 SSAS instance but there is a solution: Run the package in 32-bit mode ("C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe" /FILE "D:\SSIS\Packages\BackupAllOLAPDBs.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E) Also note that you cannot simply use the /x86 switch (which is the same as enabling the 32-bit option in the SQL job in SSMS 2008) in SQL Server 2005 because unlike in SQL Server 2008 there are 2 separate DTEXEC commands --one each for 32-bit and 64-bit. In SQL Server 2008 there is only one DTEXEC and it takes the /x86 switch, which makes the package execute in 32-bit context.