Monthly Archives: May 2009

Calculation tab not working – SQL Server 2005 Analysis Services

Posted on May 28, 2009 by

Problem/Bug: In Business Intelligence Development Studio for SQL Server 2005 analysis services, when we click on ‘Calculation’ Tab to define some calculated measures & all, we can get the following error: ‘Unexpected error occurred: ‘Error in application.’ Also having this … Continue reading →

Posted in SQL Server, SSAS | 6 Comments

Digital Signing a SSIS package (SQL Server 2005 Integration Services – Security)

Posted on May 15, 2009 by

General theory about Digital Signing & data security: In SSIS we have some options to secure our package’s content by applying certain protection levels. These defined protection levels protects the package from being viewed by unwanted users. By using these … Continue reading →

Posted in SQL Server, SSIS | 4 Comments

How to handle Nested Transactions in TSQL (SQL Server 2005)

Posted on May 9, 2009 by

In SQL Server 2000, we used to handle the errors while performing the DML queries by means of global variable @@Error. These errors may occur due to many reasons like data type mismatch, referential integrity violation etc. The @@error variable … Continue reading →

Posted in SQL Server | 7 Comments

Accessing SharePoint Lists with SQL Server Integration Services SSIS 2005

Posted on May 6, 2009 by

As now a days, sharepoint has become very propular and is widely used. And people come acorss the requirements to make share point communicate with SQL server; to & fro. And there may be need to load data from share point … Continue reading →

Posted in Others, SQL Server, SSIS | Leave a comment