#n/A in SSAS cell

Today I get strange error when I made new cube for SQL Server 2008 R2 analysis services. My cube simple  just three dimensions and a few measures. I’ve created as always role for my users and grant them “Read” right [adblockingdetector id=”5770e6ed85560″]...

SQL Command Parameter in SSIS.

I create new ETL package with SQL Server Integration Services 2005, and I was thinking that nothing can surprise me, but It seems that I was wrong. My package contains simple date parameter which I would like to pass to sql command source. But every time I’ve pressed...

Failed to decrypt protected XML node.

I had strange problem with SSIS package. I made my package in Visual Studio, all tests ran without a problem at PC station. But when I upload it to production SQL server 2005 machine job failed… What’s going on? Error message was strange: “Description: Failed to...