File system error: The following error occurred during a file operation: There is not enough space on the disk.

Since last two days my package which processes 30+ dimensions and a cube was failing with the File system error. Package was complaining that we were running out of space on file system. I checked both SSIS server and SQL Server and space was not an issue at all. After spending some time on troubleshooting I realized that when we were processing all dimensions in one ssas processing task (ssis task), package was throwing "out of space" error but after breaking the dimension processing task into multiple tasks by dividing dimensions equally into three tasks, package started running successfully for me. Now if you come across the same issue then you know what you need to do. break your dimension processing task into multiple tasks by dividing dimensions equally into multiple tasks. I am processing no more than 15 dimensions in one task.

Microsoft BI Labs

Microsoft recently launched a new site called, "Microsoft BI Labs".
http://www.microsoft.com/bi/en-us/Community/BILabs/Pages/Home.aspx

As shared on their site, "BI Labs is a collection of experimental business intelligence projects and useful applications made available from internal sources across Microsoft. These projects are prototypes and concepts, and there are no current plans to include them in Microsoft products."

Those of you who are interested in learning more about upcoming techonologies in BI world, this might be a great resource for them. They already have some interesting technologies shared on their site e.g.

1- PivotViewer Extension for Microsoft SQL Server Reporting Services

2- Microsoft SQL Server Data Mining for the Cloud

3- Fuzzy Lookup Add-in for Microsoft Excel 2010

4- MDX and DAX Formatter

5- Microsoft SQL Server Reporting Services Log Viewer

6- BI vision in multiple industries (Video Series)

Enjoy!!!